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

Question

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 1

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.

Answer 2

I had an issue similar a while back. Through other blogs and experts, I discovered that the [ID] column should not be used in a calculated column because it wreaks havoc and causes many errors. Sorry - remove the ID column and you should be fine.