Formula for "Overdue" in Status Column

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
    Paul Newcome ✭✭✭✭✭✭

    Give this a whirl...


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

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!