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
- 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