Using a Risk flag

Jessica Abbey

I want the flag if the date is past due, but it's also giving me a flag if the end date is blank. what am I missing here? I tried to add another NOT statement and ISBLANK, but then was just getting errors.

=IF(AND([End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)

Laura B.

Try this:

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

Laura B.

Try this:

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

Jessica Abbey

That did it! Thank you!