Formula for child row seq#

TMWconsultingLLC

What formula needs to be in column Step# rows 3-7 to automatically keep the Step# in sequence when a child row moves up/down?

Paul Newcome

You would need to first insert an auto-number column (called "Auto" in this example) and then a text/number column (called "Row" in this example) with the following column formula:

=MATCH(Auto@row, Auto:Auto, 0)

And another text/number column (called "Parent" in this example) with the following column formula:

=IF(COUNT(CHILDREN([Process Tittle]@row)) = 0, PARENT([Process Title]@row))

Then in the [Step #] column you would use something along the lines of

=IF(COUNT(CHILDREN([Process title]@row)) = 0, COUNTIFS(Row:Row, @cell <= Row@row, Parent:Parent, @cell = Parent@row), 0)

TMWconsultingLLC

Thanks Paul. That worked exactly as I need it to.

Paul Newcome

Happy to help. 👍️

TMWconsultingLLC

What do I need to change in the formulas get hierarchal step#'s when a step has children?

Paul Newcome

@TMWconsultingLLC You would need to look into a WBS solution. There are a number of options already out there in the Community. I suggest looking for the one that incorporates column formulas.