Red Flag Formula
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!
Help Article Resources
Check out the Formula Handbook template!