Sign in to submit new ideas and vote
Get Started

Resetting Auto-numbering for columns in templates and sheets

Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you have to start all over and create another sheet. In the case where the sheet has already been created and there is a desire to change or restart the numbering system, it just isn't possible, and that is frustrating. This is especially problematic when the sheet is shared with a client and other teammates from other organizations. It's hard enough to get people to use the multiple tools we have available to us these days, and when you have to re-share items simply because an existing column or new column within a sheet that has had a auto-numbering previously cannot be corrected or reset back to 1 (or whatever number that is desired), that is not efficient and it is hard to explain to my clients and teammates - they get frustrated too. Hoping you can fix or enhance this feature soon.

1
Up
1 votes

Idea Submitted·Last Updated

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you have to start all over and create another sheet. In the case where the sheet has already been created and there is a desire to change or restart the numbering system, it just isn't possible, and that is frustrating. This is especially problematic when the sheet is shared with a client and other teammates from other organizations. It's hard enough to get people to use the multiple tools we have available to us these days, and when you have to re-share items simply because an existing column or new column within a sheet that has had a auto-numbering previously cannot be corrected or reset back to 1 (or whatever number that is desired), that is not efficient and it is hard to explain to my clients and teammates - they get frustrated too. Hoping you can fix or enhance this feature soon.<\/p>","bodyRaw":"[{\"insert\":\"Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you have to start all over and create another sheet. In the case where the sheet has already been created and there is a desire to change or restart the numbering system, it just isn't possible, and that is frustrating. This is especially problematic when the sheet is shared with a client and other teammates from other organizations. It's hard enough to get people to use the multiple tools we have available to us these days, and when you have to re-share items simply because an existing column or new column within a sheet that has had a auto-numbering previously cannot be corrected or reset back to 1 (or whatever number that is desired), that is not efficient and it is hard to explain to my clients and teammates - they get frustrated too. Hoping you can fix or enhance this feature soon. \\n\"}]","format":"rich","dateInserted":"2023-08-21T17:31:22+00:00","insertUser":{"userID":74181,"name":"Ty","url":"https:\/\/community.smartsheet.com\/profile\/Ty","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!oSHY6BmpkHw!w7lVf7X_hLo!OJUnkUS0v_V","dateLastActive":"2023-08-21T19:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/109214\/resetting-auto-numbering-for-columns-in-templates-and-sheets","embedType":"quote","name":"Resetting Auto-numbering for columns in templates and sheets"}"> https://community.smartsheet.com/discussion/109214/resetting-auto-numbering-for-columns-in-templates-and-sheets

    Hi,

    I hope you're well and safe!

    That's not correct! You can reset the count whenever you like.

    Try something like this.

    1. Change the column properties from Auto-Number/System... to Text/Number
    2. Save
    3. Delete the numbers you don't want
    4. Save
    5. Delete the rows with the numbers you deleted
    6. Save
    7. Change the column back to Auto Number and change the Starting Number to the number you'd like the next added row to be
    8. Save
    9. Add a new row
    10. Save and watch the magic happen

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.