Auto Numbering

Good Morning,

I have multiple sheets that filter into the master sheet. The individual sheets have auto number columns, which then transfer over to the master column. We would like to number each row individually of the master column, however the auto number option is already used. Is there a formula that can be used to number each row?

Thank you!

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    On your master sheet, in the column you want to use for auto-number, place your first number.

    (Let's assume you name that column [Master Number] and the first number is 1.)

    In the next cell down, place this formula [Master Number]@row+1. The result should be 2. Now, drag this formula down the rest of the column, and you should see each number progress by 1 (e.g., 3, 4, 5, 6, etc.)

    If your numbering system uses prefixes or suffixes, that's a more complex solution that will require some helper columns. Let me know if that's what you need.

  • CaraBart28
    CaraBart28 ✭✭✭✭

    Hi @Danielle Arteaga that works, however, is there a way to get the number to display only when a new row is added? When I do as listed above then it throws off the columns that follow it...


  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    Not sure what you mean by "throws off the columns that follow." Adding a new column shouldn't impact the Master Order # column at all. Can you share a screen cap of what's happening?

  • CaraBart28
    CaraBart28 ✭✭✭✭

    As you can see it numbers and timestamps the next few columns


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!