I have a Tasks List
A new calculated column added to it Task_ID
a. Formula used -
It produces a column having values like
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
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?