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
-
Gia Thinh ✭✭✭✭✭✭
I got it. Change the Starting number to the number you want for a new row. Hope this works.
I love processes, worflows, automation, co-operation and technology. That's why I built a mini ERP solution for businesses.
Answers
-
Gia Thinh ✭✭✭✭✭✭
Hi Carmen,
It's strange to hear that. Can you show a screenshot to demostrate your situation?
I love processes, worflows, automation, co-operation and technology. That's why I built a mini ERP solution for businesses.
-
Carmen W ✭
Hi Gia,
谢谢你让英航ck.
Sure here are some screenshots:
The auto number row is called "RowID"
And here are some duplicated numbers:
-
Gia Thinh ✭✭✭✭✭✭
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.
I love processes, worflows, automation, co-operation and technology. That's why I built a mini ERP solution for businesses.
-
Carmen W ✭
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.
-
Gia Thinh ✭✭✭✭✭✭
I got it. Change the Starting number to the number you want for a new row. Hope this works.
I love processes, worflows, automation, co-operation and technology. That's why I built a mini ERP solution for businesses.
-
Carmen W ✭
Thank you Gia,
I will do this and hopefully won't see this error again.
Categories
You would use an IF\/COUNTIFS combo to count how many rows have the employee ID and the Week Starting. If that count is greater than zero (meaning there was at least one entry), check the box.<\/p>
<\/p>
=IF(COUNTIFS({Source Sheet EMP ID}, @cell = [Employee ID]@row, {Source Sheet Week Starting}, @cell = \"7\/10\/2023\")> 0, 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":108515,"type":"question","name":"What is the best way to make a report that pulls from a very large sheet (14K+ lines)?","excerpt":"My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?","snippet":"My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all…","categoryID":321,"dateInserted":"2023-08-03T22:34:48+00:00","dateUpdated":null,"dateLastComment":"2023-08-04T18:39:33+00:00","insertUserID":163583,"insertUser":{"userID":163583,"name":"Rachel Apostol","title":"Facilities Manager","url":"https:\/\/community.smartsheet.com\/profile\/Rachel%20Apostol","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G5DD3ykb4-Y!peFCqaEjsfo!_LY7eglrUWX","dateLastActive":"2023-08-04T20:29:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-04T19:26:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":46,"score":null,"hot":3382280061,"url":"https:\/\/community.smartsheet.com\/discussion\/108515\/what-is-the-best-way-to-make-a-report-that-pulls-from-a-very-large-sheet-14k-lines","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108515\/what-is-the-best-way-to-make-a-report-that-pulls-from-a-very-large-sheet-14k-lines","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":108515,"commentID":389007,"name":"Re: What is the best way to make a report that pulls from a very large sheet (14K+ lines)?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389007#Comment_389007","dateInserted":"2023-08-04T18:39:33+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-04T19:26:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-04T16:24:31+00:00","dateAnswered":"2023-08-04T16:20:05+00:00","acceptedAnswers":[{"commentID":388979,"body":"
Hi @Rachel Apostol<\/a> <\/p> Do you have Grouping applied to your Report<\/a>? Grouping will limit what the report can show:<\/p>