Forum Discussion
Calculated column in Sharepoint List loses changes to formula
Using ID column in SharePoint calculated column is not supported by Microsoft offcially.
However, if it is returning correct ID in calculated column for you, try using this formula for LineID column:
="00"&[ID]Wrap 00 in double quotes.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap Thanks, i tried it - and it behaves as before - the square brackets disappear after submitting a new line.
I guess that if using ID in a Calculated Column is not supported, i need to find a different way. I'm not great at programming - do you have any suggestions?
jonengland This is a default behavior in SharePoint calculated formulas to remove the square brackets for the columns having 1 word name (Example: Title, ID, Created, DeviceID etc.) after saving the formula.
Square brackets are required only when you have more than 1 words in column name or when you have space in column name (Example: [My Column 1], [Due Date], [Email Address]).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thanks for the explainer on square brackets ganeshsanap - very helpful!
