Formula Insertion via Conditional Formatting

Thatguy23

Hi,

I've made several formulas for one of my sheets to identify task health based on several conditions, which all work fine. However, my problem is when I insert a new row I need to identify the health formula for that row based on the task indent level (parent/child/grandchild) which I don't know how to do. Has this been done before?

Thanks

Hollie Green

You can identify with a helper column. One formula I use in my helper column is

=COUNT(ANCESTORS()) + 1

You can then set up your criteria based on the number in the helper column. 1 would be a parent row, 2 a child, 3 a grandchild.

Hollie Green

You can identify with a helper column. One formula I use in my helper column is

=COUNT(ANCESTORS()) + 1

You can then set up your criteria based on the number in the helper column. 1 would be a parent row, 2 a child, 3 a grandchild.

Thatguy23

That worked perfectly! Thank you @Hollie Green