Menu
In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?
503
Fill a column with a series of numbersSelect the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern. Tip: For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells.
Navigate to your list, Select the little drop-down in the target column, Choose “Column Settings” >> Select “Format this column”.
Sharepoint Lists automatically have an column with "ID" which auto increments. You simply need to select this column from the "modify view" screen to view it.
149
You can't add a new unique auto-generated ID to a SharePoint list, but there already is one there! If you edit the "All Items" view you will see a list of columns that do not have the display option checked.
There are quite a few of these columns that exist but that are never displayed, like "Created By" and "Created". These fields are used within SharePoint, but they are not displayed by default so as not to clutter up the display. You can't edit these fields, but you can display them to the user. if you check the "Display" box beside the ID field you will get a unique and auto-generated ID field displayed in your list.
Check out: Unique ID in SharePoint list
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
