COUNTIFS with multiple criteria

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.

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.