Auto Numbering
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!