Formula to ID indent level

Travis Myers

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.

Bassam Khalil

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

Will Kremer

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()))