Red Flag Formula

ttopfer ✭✭
edited 12/09/19 in Formulas and Functions

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!

Smartsheet Q 24.9.19.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!