[Question] Auto Incrementing serial number without Workflow

%3CLINGO-SUB%20id%3D%22lingo-sub-211268%22%20slang%3D%22en-US%22%3E%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211268%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20calculated%20field%20column%20on%20a%20list%26nbsp%3Bin%20order%20to%20implement%20a%20custom%20ID%20for%20my%20projects.%20However%2C%20I%20cannot%20seem%20to%20be%20able%20to%20insert%20an%20auto%20incrementing%20number%20(ID%20column%20is%20not%20available%20for%20calculated%20values).%20I%20did%20a%20search%20and%20found%20some%20solutions%20using%20workflows%2C%20but%20I%20would%20prefer%20a%20solution%20without%20them.%20Can%20you%20help%20me%3F%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211561%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211561%22%20slang%3D%22en-US%22%3ECould%20you%20be%20a%20little%20more%20specific%3F%20i%20dont%20mind%20using%20PowerApps%20as%20long%20as%20it%20works.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211560%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211560%22%20slang%3D%22en-US%22%3EI%20believe%20that%20in%20my%20case%20this%20does%20not%20work!%20it%20does%20not%20update%20the%20calculated%20column%20on%20new%20entries%2C%20and%20i%20have%20to%20edit%20the%20column%20for%20the%20id%20to%20be%20inserted.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211326%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F161262%22%20target%3D%22_blank%22%3E%40admin%20fnetwork%3C%2FA%3E%26nbsp%3Byou%20can%20still%20use%20the%20calculated%20column%20for%20ID%20even%20thou%20it's%20not%20listed%2C%20just%20go%20into%20the%20formula%20field%20and%20do%20something%20like%20this%20%3D%22TestID-%22%26amp%3B%5BID%5D%20and%20you'll%20get%20TestID-24%20for%20example.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211294%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211294%22%20slang%3D%22en-US%22%3EIf%20you%20don't%20want%20to%20use%20a%20Workflow%20or%20even%20some%20programming%2C%20I%20would%20recommend%20you%20to%20explore%20PowerApps%20possibilities%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211292%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211292%22%20slang%3D%22en-US%22%3EI'm%20sorry%2C%20i%20was%20talking%20about%20Sharepoint%20online!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211284%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Auto%20Incrementing%20serial%20number%20without%20Workflow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211284%22%20slang%3D%22en-US%22%3EAre%20you%20talking%20about%20SharePoint%20OnPrem%20or%20SharePoint%20Online%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,

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
Highlighted
Are you talking about SharePoint OnPrem or SharePoint Online?
Highlighted
I'm sorry, i was talking about Sharepoint online!
Highlighted
If you don't want to use a Workflow or even some programming, I would recommend you to explore PowerApps possibilities
Highlighted

@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. 

Highlighted
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.
Highlighted
Could you be a little more specific? i dont mind using PowerApps as long as it works.