Auto number column giving duplicated numbers
Hi All,
I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula.
Does anyone know why it is giving duplicate numbers?
Thanks.
Best Answer
-
I got it. Change the Starting number to the number you want for a new row. Hope this works.
Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
Hi Carmen,
It's strange to hear that. Can you show a screenshot to demostrate your situation?
Gia Thinh Technology - Smartsheet Solution Partner.
-
Hi Gia,
Thank you for getting back.
Sure here are some screenshots:
The auto number row is called "RowID"
And here are some duplicated numbers:
-
The numbers in RowID are not in the order of increasing. It seems that the duplicated rows (ex 3624, 3625 at the bottom) are copied from another sheet (B) to your sheet (A). You may want to check this in activity log as below screenshot. If it is the case, you may ask for help from your internal IT.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Hi Gia,
The sheet was created by saving another sheet as a new sheet and that other sheet doesn't have this duplicate number issues.
What's more weird is when I deleted the rows with duplicated numbers and recreated those rows by copy/paste rows within the same sheet, RowID row again produce duplicated numbers, just different ones.
-
I got it. Change the Starting number to the number you want for a new row. Hope this works.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Thank you Gia,
I will do this and hopefully won't see this error again.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives