Forum Discussion

jonengland's avatar
jonengland
Copper Contributor
Nov 24, 2023
Solved

Calculated column in Sharepoint List loses changes to formula

I'm trying to use the built in ID column in the Sharepoint List to add to a "Device ID" for an IT inventory list. My idea is to take the row "ID" number and add a couple of zeros in a new Column call...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Nov 24, 2023

    jonengland 

     

    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's avatar
ganeshsanap
MVP
Nov 24, 2023

jonengland 

 

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.

jonengland's avatar
jonengland
Copper Contributor
Nov 27, 2023
Thanks for your help on this ganeshsanap - It's looks as though Microsoft not supporting the ID column's use in Calculated Columns is causing my issue here. Thanks for that info!

Resources