Auto Number Reset

Options
TAbs
TAbs ✭✭
edited 10/23/23 in Smartsheet Basics

Is there a way to reset the auto number to 1? I've been testing formulas on this sheet and even though I have deleted the lines it is still counting them. Is there a way to reset it?


Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 01/19/23
    Options

    Hi @TAbs

    I hope you're well and safe!

    Yes, there is a way to start over again.

    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!

    Have a fantastic week & Happy New Year!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Gretchen Good
    Options

    Hi Andree this did not work for me, it did not reset to "1"?

    Any other ideas?

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hey @Gretchen Good

    @Andrée Starå's steps above look good to me! Is it possible that you may have missed a part of Step 7, where you would need to change the Starting Number when you go to set up the column as Auto Number again?