Formula to ID indent level
I am trying to perfect a formula that I am currently using to make it a bit more robust.
Currently the formula I am using to ID indent level is:
=IF(COUNT(CHILDREN([Job Name]@row)) > 0, COUNT(ANCESTORS()) + 1)
This works until I end up with grandchild rows. Below is a screenshot of a sheet to better articulate what I am after.
Main reason for this is for sorting as currently when we sort by the primary column, the child/grandchild rows become a jumbled mess.
Answers
-
Hi @Travis Myers
Hope you are fine, @Tom Zylstra had created a very good solution for Work Breakdown structure, please check his post i think you will find a great help for your case:
Work Breakdown Structure (WBS) - Column Formula Configuration
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Travis Myers,
I am a little late here but I took your initial statement and added a value for if it is false (so fi the children rows are not greater than 0) and it seems to be working for my grandchild rows now. Hope you found a solution in the meantime but if not I hope this helps!
=IF(COUNT(CHILDREN(Deliverable@row)) > 0, COUNT(ANCESTORS()), COUNT(ANCESTORS()))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!