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


Sign In or Register to comment.