sequential number for each parent row - column formula


im trying to generate a sequential number for each parent row.

I can do this using an helper column called parent that flags each parent record with 1 then the formula @row, 1)

this won't convert to a column formula because of the explicit row references used to define the range.

can it be done.

any help appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!