Is there a way to add new unique auto-generated ID for every new item added to a custom list? I would like the numbering to start at 300 as I will be uploading data to the list which already have been allocated a unique ID.

Many thanks

  • Im using SharePoint 2013 – Louise13 May 24 '16 at 14:36

List already had an auto Id field. This starts at 1 and auto increment as new entry is added.

You can create a calculated field and use a formula like

= 300 + [Id]
  • 2
    Just beware that using Id in calculated columns is not reliable: sharepoint.stackexchange.com/questions/22977/… – Robert Lindgren May 24 '16 at 14:22
  • The SharePoint auto ID is out of sync with my created ID due to testing and deleting dummy data, so I can use it, – Louise13 May 24 '16 at 14:29
  • Which is your SharePoint version? – Amal Hashim May 24 '16 at 14:30
  • Using a workflow to generate it would be more reliable, calculated columns with the ID column is horribly unreliable. – Eric Alexander May 24 '16 at 14:43
  • HI there, can you tell me how to create a workflow to do this? I would like my numbering to start from 300 – Louise13 Jun 14 '16 at 14:50

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.