3 Conditions Formula
I want to have a flag turn red if 1. A task is considered a milestone, 2. The Planned End Date is today or before, and 3. The task is not done.
The below formula is not working:
=-IF(AND([Is Milestone]@row, 1, [email protected], 0, [Planned End Date]@row < TODAY()), 1, 0)