SharePoint: Calculated Column Values Disappear When Editing List Item. Any ideas?

sharepoint calculated-columns
program247365 picture program247365 · Jul 7, 2009 · Viewed 20.2k times · Source

I have a calculated column in a custom SharePoint 2007 list, with the following formula:

=CONCATENATE("IR-",[ID],"-",LEFT(UPPER([Title]),25))

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".

Anyone have some insight on why this would be happening?

Answer

Kit Menke picture Kit Menke · Jul 9, 2009

I confirm the behavior mentioned above. Any Add/Edit will wipe out the [ID] portion. 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.

Sounds like the only solution would be to make a simple workflow using SharePoint Designer that would update a text field in your list.

Related questions

Sharepoint, Calculated column, IF function and date

I am trying to add a calculated column. I have a date column containing the date a meeting is scheduled. From this column I need a code which can return if the meeting is scheduled in Q1, Q2, Q3 or …

Read More
Best way to resolve file path too long exception

I created a app that downloads all document libraries in a SP Site , but at one point it giving me this error (I tried looking at google but couldn;t find anything, now if anyone knows any trick to solve …

Read More
Auto number column in SharePoint list

In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?

Read More