I have a list in SharePoint where I need to have a auto incremented customized ID when an item is created. I know SharePoint list already has a default ID but I need my ID to be customized with a code. Example: my ID should display as AMS-0001

I have a solution but it gives the same ID every time a new item is created.

Any idea on how to do this?

  1. Create a new column, such as : Increment Number in issue list with Number type. Make this column hidden in a view.
  2. Create another column, such as : Issue No. in issue list with Formula type and add the following formula = "AMS-00" & [Increment Number]. This Column will show the increment items’ numbers in the list.
  3. Open SharePoint designer, create new list workflow (for issues list).
  4. Add a workflow action: “Update list Item” >> Current Item >> Add >> Set this field to your Target field (Increment Number), set value from Current Item:ID field (as below):

enter image description here

enter image description here


How to Create an Auto-Incrementing Number Field in a SharePoint List

| improve this answer | |
  • Hi, this solution is awesome but unfortunately I don't use SharePoint designer and I have created this list using SharePoint online. Any other possible method? Anyways thank you for sharing this awesome solution. – Imesha Siriwardane Apr 29 '19 at 10:12
  • Calculated column won't work for new created items, for this case, the solution above is the best option. You could download SharePoint Designer, this is for free to use and could download here: microsoft.com/en-eg/download/details.aspx?id=35491 – Jerry_MSFT Apr 30 '19 at 2:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.