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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives