3 Conditions Formula

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)

Best Answers

Answers

Sign In or Register to comment.