Red flag if the END DATE is past AND not blank, and if the STATUS is not complete.

System

This discussion was created from comments split from: Flag task as late where task incomplete and past due date.

Damientronus

This formula gets me closer to what I need to do. Here's my version of the working formula above that "works" but isn't doing what I want.

=IF(AND(Status@row <> "Complete", [End Date]@row <= TODAY()), 1)

What I need is the following in English:

Only Raise a red flag if the END DATE is in the past, if the END DATE is not blank, and if the STATUS is not complete.

Your assistance is much appreciated. I'm not great with these advanced formulas.

Dan W

=IF(AND([End Date]@row <= TODAY(), Status@row <> "Complete", [End Date]@row <> ""), "RED", "")

You can change the "Red" to whatever you need. If its a check box you can simply change it to ""), 1,"")