I have a List with a Calculated Column. The calculated column include Item ID like ID&";#"&[Sales Manager].
It works fine, but when I edit an item, the calculated column of that given Item losses the ID portion.
When I go back and edit the formula and save it (with or without any change in formula). Calculated field reads the ID fine. Any item which is not edited since last save of formual remains good.
How can I make the Item ID to stay in the Calculated field?