Autonumber column keeps changing to previous starting number
Jennifer Shannon
✭✭✭
Not sure if sorting a sheet is causing this, but the starting number for a column continually changes to a previous start number. For example. The starting number should be 071, but somehow it is showing to start at 059.
Any suggestions on how to stop this from occurring or what may be causing it?
Answers
-
If you've deleted rows that used to have a number, the auto number will then skip the deleted columns and start numbering at the first non deleted row. That's what happened to me at least 😄.
If that happens I'll change the column to text/ number, deleted the numbers, then change it back to auto number.
-
Thanks Tim. I will see if the end user is doing that. Appreciate the reply!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives