Formula to count status and due date in the past

11/26/20
Answered - Pending Review

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

Answers

  • 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())

    Thanks,

    Aravind

    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E: [email protected]

    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!

Sign In or Register to comment.