Auto Numbering

rgalasso

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!

Kathleen H.

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.

rgalasso

Thank you, I will try that