SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to create an autonumber column in the lists and libraries?
For example I want to have a list and when a user wants to add a new value, it automatically generates a new autonumber.

share|improve this question
Can you just use the built in ID column? – Ryan Oct 17 '12 at 8:09
up vote -2 down vote accepted

When you create any list or Library a column named ID is created automatically and it is Auto-number Column; And if you want to create your own autonumber column you can create it with Calculated Type of Column.

share|improve this answer
The link you specified to customise the autonumber is actually a question stating it doesn't work as expected using the calculated column. – Russell Oct 17 '12 at 5:26
hey Sorry i got wrong link.. try this link.. this shows how to create Autonumber Column in List..… – Torque Oct 17 '12 at 5:29
That looks...erm... pretty useless. Its just ID+1. Whats the advantage of that over just the existing ID column? – Ryan Oct 17 '12 at 8:10
Unfortunately using [ID] in a calculated column doesn't work: – Stuart Pegg Oct 17 '12 at 8:17

If you want to show this number on AllItems.aspx page, you can use xslt. In spd add a column at the beginning of the table for examaple and add there this formula: position() It will show so-called 'id' of each item of the list

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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