Removing parents from formula.

WG

Can anyone please assist with structuring this formula so the report does not include parent rows?

=IF(AND(Due@row < TODAY(), State@row <> "Complete"), "Red", "Green")

Thanks!

WG

Bassam Khalil

Hi @WG

Hope you are fine, you can solve that by adding a helper column in the source sheet to define the parent level and filter your report by using level 0 as a filter, the following is the formula that define the parent level:

=IF(COUNT(CHILDREN(Task@row)) > 0, COUNT(ANCESTORS()) + 1)