Auto Numbering
Options
I'd like to write a formula that auto numbers each parent row in a sheet, advancing one number from the prior row. I would ideally like to set this up as a column formula so that each time I enter a new row of data, the number advances to the next instance without having to copy the formula. I would only like the next number to appear when data is entered into the primary column. Is there a way to do this? Thanks!
Answers

Try =COUNT(ANCESTORS()) and apply it to the column.
If you add conditional formatting to each level it's much smoother as you build vs. having to format manually.

Thank you, I will try that
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!