Trouble with Auto Number column type. Shows up different in cell.
Sarah_lee
✭✭✭
Hello,
I am trying to use the auto number system and am having a little trouble.
You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate as C001.
From the second image, you can see how it populates in the cell. It is stating with the number C011 instead.
Can anyone explain to me what is happening and how this auto number concept works.
Thanks in advance.
Answers
-
The auto-number counter begins at the time that the column is created. It's likely that 10 rows had been created and deleted between the column's creation time and the time that it was reconfigured.
To renumber the rows without deleting the column:
- Change the column to a Text/Number column type.
- Delete the values in that column and save the sheet.
- Refresh\reload your browser page.
- Change the column to an Auto number column type, configuring it as needed, and save the sheet.
Step #3 is key.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 383 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives