Formula to flag overdue Items with 2 conditions
I am currently using this formula to indicate if a task is overdue (via a flag).
=IF(AND(NOT(ISBLANK([End Date]@row)), [End Date]@row < TODAY()), 1, 0)
I just realized that the Overdue flag is still red when the Status is 'Complete.' How do I add this into my formula? Tried to add NOT(Status@row= "Complete") but I'm either not putting it in the formula correctly or it's not the appropriate one to add.
Thanks in advance for your help!
Help Article Resources
Check out the Formula Handbook template!