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

SuzanoSho Consider this:

1. For existing list items: create a power automate flow with manual trigger, read all item using "Get items" action and then update column value using ID from dynamic content for each list items - This will be one time activity only
2. For new items (in future): create a automated power automate flow with "When an item is created" trigger and use single "Update item" action which will update column value using ID from dynamic content

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.

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.