COUNTIFS with multiple criteria

KaisaB

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.

brianschmidt

@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!:)

brianschmidt

@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!:)

KaisaB

Thanks! That worked!

brianschmidt

https://community.smartsheet.com/discussion/comment/428373#Comment_428373

Awesome! Glad to hear it:)