Scenario:
I have a Tasks List
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?