A way to automatically number a list?

Aaron Kennedy

I have a sheet with about 2000 entries, we had a problem where they were shuffled around and since the smartsheet rows are numbered the same no matter what is in them, I was wondering if there was a column formula or something to automatically number each row sequentially and will automatically give the next number to the next row when added (ex: 2000 rows and I add another and it is automatically numbered 2001) I just want a way to basically have my own number row so each row has its own unique value that will be easy to track even if shifted around.

Kelly P.

@Aaron Kennedy

Did you try the column type "Auto number"? You can specify within pop up box how you want the numbering to look (prefix/suffix), what number to start with, and the number of places each number should have.

Hope that helps!