Formula for "Overdue" in Status Column

11/27/19 Edited 12/09/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

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Give this a whirl...

     

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

    thinkspi.com

Sign In or Register to comment.