Red Flag Formula

ttopfer

Hi All,

Hoping to get some assistance with 2 questions. 

1. In the Child rows, I would like the flag to go red when today's date is past the finish date AND % Complete is < 100% (ie the task is past the due date and not 100% complete).

2. The flag in the parent row (Black Circle) turns red IF any of the child row flags are red below it (Red circle).

Thanks for your assistance in advance!

Paul Newcome

In the child rows:

 

=IF(AND([% Complete]@row < 1, [Finish Date]@row < TODAY()), 1)

 

and in the Parent row:

 

=IF(COUNTIFS(CHILDREN(), 1) > 0, 1)