[Question] Auto Incrementing serial number without Workflow

Occasional Contributor


I would like to create a calculated field column on a list in order to implement a custom ID for my projects. However, I cannot seem to be able to insert an auto incrementing number (ID column is not available for calculated values). I did a search and found some solutions using workflows, but I would prefer a solution without them. Can you help me?

Thank you.

6 Replies
Are you talking about SharePoint OnPrem or SharePoint Online?
I'm sorry, i was talking about Sharepoint online!
If you don't want to use a Workflow or even some programming, I would recommend you to explore PowerApps possibilities

@admin fnetwork you can still use the calculated column for ID even thou it's not listed, just go into the formula field and do something like this ="TestID-"&[ID] and you'll get TestID-24 for example. 

I believe that in my case this does not work! it does not update the calculated column on new entries, and i have to edit the column for the id to be inserted.
Could you be a little more specific? i dont mind using PowerApps as long as it works.