3

Scenario:

  1. I have a Tasks List
  2. A new calculated column added to it Task_ID

    a. Formula used -

    =CONCATENATE("TL_",ID)

It produces a column having values like TL_1, TL_2 .. and so on.

Now whenever anything changes in a list item (may be Task Status or anything else) the calculated column value changes to TL_

I have to goto the calculated column in the List Settings and hit OK button to re calculate the values.

How can I correct this auto update the values?

  • 1
    Known Issue, the ID column isn't supported in calculated columns, use a workflow/event receiver like Arvind says – Eric Alexander Jul 7 '16 at 4:10
5

The ID field you are trying to use in your Calculated Column is not known until the Item is saved . Hence using it in your calculated column may not give you the required output.You can use an event handler or a workflow to update the list items. My preference would be a simple workflow that runs when the items are created.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.