Contents
If an item is created in the list, everything is fine, however, when an item is updated the [ID] column is no longer in the calculated column for that item. So, on creation: “IR-40-TheTitleIsHere”, but after edit, it is, “IR–TheTitleIsHere”.
Open SharePoint Designer. Open the website that contains your list with the calculated column. Click on “Lists and Libraries” in the left column (under Site Objects). On the right, click on the list that contains your calculated column. In the column “Property”, try clicking a few times on the “Optional” value until it changes into a dropdown list.
How can I update column values in SharePoint?
If you edit the column in the list and update the formula, it will update ALL list items to be correct (until you do an edit on the item). I found this post that mentions the same problem.
How to use calculated columns to write HTML?
This site — http://blog.pathtosharepoint.com/2008/09/01/using-calculated-columns-to-write-html/ — gives an example of how to use javascript in the same manner that I used it.. the important block of code is the first while loop. The point is to grab the out of box ID column from the list and update whatever calculated field needs the ID.
What happens when column data type is changed?
In which all other columns’ values get retained. But the column for which data type is changed to multiline, get overwritten with empty multiline field. If versioning is set off for corresponding list, the latest version with empty multiline field will be overwritten on existing record. And so all the data will be lost.
What happens when you change data type to multiline?
When we change data type of single line text column to multiline, new version of all items is created. In which all other columns’ values get retained. But the column for which data type is changed to multiline, get overwritten with empty multiline field.
How to change column data type in SharePoint?
In section Additional Column Settings, select Yes for Append Changes to Existing Text option. This will change the column data type, as well as retain the old value of respective column (Append changes to Existing Text is set to Yes).