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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!