Formula for child row seq#
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?
Answers
-
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)
-
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!