Forum Discussion

SuzanoSho's avatar
SuzanoSho
Copper Contributor
Oct 07, 2022

Using the ID column to generate a number in a calculated column.

Hello. I was wondering if I could get some help with an issue I'm currently having. I'm trying to generate a ticket number system based on the ID column for an existing sharepoint list. The new ca...
SharePoint Online
SuzanoSho's avatar
SuzanoSho
Copper Contributor
Oct 08, 2022
Well, the list is already populated with items. I'm not sure that kind of flow would work retroactively.
ganeshsanap's avatar
ganeshsanap
MVP
Oct 08, 2022

SuzanoSho First of all, SharePoint ID column is not supported in calculated column formula officially. But, it will not throw any error while you use [ID] in formula and try to save the column settings.

 

Anyway, I tried using the same formula you provided and it is working for existing items in list: 

But, it will not work for new items created in list (item ID 15) because ID cannot be used in calculated column in case of new items.

 

Also, when you will update any list item column (item ID 15), calculated column value will change & it will not have ID in it until you go to column settings and save the formula again: 

 

As per the How to use SharePoint ID field in Calculated Column? ,

The SharePoint ID field is not calculated in the calculated column until you manually update the formula in the calculated column field settings.

 

Conclusion: Avoid using ID in calculated column and use Power automate flow/designer flow instead.

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.

Resources