Formula for "Overdue" in Status Column

Irishalum2002 · 11/27/19

I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply or work when I input them. Please let me know your thoughts. Thank you!

Screen Shot 2019-11-27 at 8.32.03 AM.png

Paul Newcome · 11/27/19

Give this a whirl...

=IF([% Complete]@row = 1, "Complete", IF([End Date]@row < TODAY(), "Overdue", IF([% Complete]@row = 0, "Pending", "In Progress")))

Formula for "Overdue" in Status Column

Comments

Help Article Resources

Categories