COUNTIFS with multiple criteria

KaisaB
KaisaB
edited 03/22/24 in Formulas and Functions

I am trying to count the number of projects with a due date in the past and a Status of In Progress, In Review, or On Hold. This is what I have, but it returns unparseable.

=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY (), [Status:Status, ="In Progress"], [Status:Status, ="In Review"], [Status:Status, ="On Hold"])

Can you help?

Thanks.

Best Answer

  • brianschmidt
    brianschmidt ✭✭✭✭✭
    edited 03/22/24 Answer ✓

    @KaisaB

    Looks like you have a few sets of brackets where they don't need to be, you have a space at the end of TODAY function that is causing problems, and you need an "OR" condition. Try this instead:

    =COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY(), Status:Status, OR(@cell="In Progress", @cell= "In Review", @cell= "On Hold"))

    Hope this helps!:)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!