Formula to Check a box at different indention levels

Ryan Levitz

Hey there,

Trying to figure out a formula to automatically check the boxes based on how many times a task has been indented, like this:

I know I can set the Activity column to: =IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1), but I don't know how to do the others. Any help would be appreciated!

Paul Newcome

Instead of counting children, count ancestors. The leftmost indentation will result in a zero from the COUNT.

=IF(COUNT(ANCESTORS([Task Name]@row)) = 0, 1)

would be for the Department column.

1 would be for the Category column, 2 for the Initiative column, so on and so forth.

Paul Newcome

Instead of counting children, count ancestors. The leftmost indentation will result in a zero from the COUNT.

=IF(COUNT(ANCESTORS([Task Name]@row)) = 0, 1)

would be for the Department column.

1 would be for the Category column, 2 for the Initiative column, so on and so forth.

Ryan Levitz

Super simple. Love it. Thanks Paul!

Paul Newcome

Happy to help. 👍️