Formula for child row seq#
What formula needs to be in column Step# rows 37 to automatically keep the Step# in sequence when a child row moves up/down?
Answers

You would need to first insert an autonumber 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)

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

Happy to help. 👍️

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

@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.
Help Article Resources
Categories
Check out the Formula Handbook template!