Is it possible to update an auto-number field that was incorrectly input the first time?
Hi All! A request came in to modify an existing auto-number field that was input incorrectly the first time. This wasn't a Smartsheet error, it was a user error. The creator of the sheet did not have the auto-numbering system set up to include the current year {YY}. I've corrected that issue but now I need to correct the old rows that were auto-numbered with the year they were created.
Suggestions?
Best Answer
-
Hi @Shelby
There are a few ways you can do this.
Depending on how your numbering is set up, you could just delete the current Auto-Number column and then re-insert the column with the correct set up. However this will re-number your rows, so if there are some rows that had been moved or deleted your numbering will change. (See the "Notes" at the bottom of the top section of this Help Article: Auto-Number Rows).
Another way to do this would be to change the current Auto-Number column into a regular text column. Then adjust the rows that need the {yy} addition to have the correct data. Once the values are correct, change the Column Properties back to being an Auto-Number column.
Keep in mind with this option you'll want to ensure you have the right "Starting Number" set in your Column Properties so it starts off where the data currently ends. (See: Turn an Existing Column into an Auto-Number Column).
Let me know if either of these work for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Shelby
There are a few ways you can do this.
Depending on how your numbering is set up, you could just delete the current Auto-Number column and then re-insert the column with the correct set up. However this will re-number your rows, so if there are some rows that had been moved or deleted your numbering will change. (See the "Notes" at the bottom of the top section of this Help Article: Auto-Number Rows).
Another way to do this would be to change the current Auto-Number column into a regular text column. Then adjust the rows that need the {yy} addition to have the correct data. Once the values are correct, change the Column Properties back to being an Auto-Number column.
Keep in mind with this option you'll want to ensure you have the right "Starting Number" set in your Column Properties so it starts off where the data currently ends. (See: Turn an Existing Column into an Auto-Number Column).
Let me know if either of these work for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!