A way to automatically number a list?
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.
Answers
-
@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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!