Formula to count status and due date in the past


Hi, hoping that someone can help...

I'm trying to add a field into my Sheet Summary, to highlight tasks that are overdue, but need to excluded tasks that are 'Complete'. This is what I've tried, however the error message is #Unparseable.

=COUNTIF(Launch:Launch), <TODAY(), + COUNTIF(Status:Status, "In Progress"), (Status:Status, "Under Analysis")

Any ideas? Thank you


  • Aravind GP
    Aravind GP ✭✭✭

    Hi Simone,

    It will be helpful if you can give a screenshot. You can possibly use this formula.

    =COUNTIFS(Status:Status, "In Progress", Launch:Launch, <TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, <TODAY())



    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E:

    Feel free to reach out for licenses, services, and training on Smartsheet

  • Perfect, thank you! This is what has worked :)

    =COUNTIFS(Status:Status, "In Progress", Launch:Launch, @cell < TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, @cell < TODAY())

    For some reason if I excluded the '@cell' it didn't work, but it's all good now!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!