Issues with Numbering Children (Child 1, Child 2, etc.)

Lucia Herfer

Hi!

I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following:

1. Create an auxiliary column with a "1" each time a child is found.
2. Create a column that sums the entire auxiliary column up to the current row, using this formula:
   =SUMIF([Row]:[Row], <[Row]@row, [Aux]:[Aux]).

The issue with this formula is that Smartsheet tells me there are too many calculations in the sheet and it cannot save it. I tried limiting it with a first IF, but it still doesn't work.

Do you have any suggestions for achieving this while keeping the main objective, which is to be able to use it as a column formula?

Thank you in advance for your help!