CountIFs referencing multiple columns, one of which is multi-select

I am trying to do COUNTIFS with multiple criteria/columns, referencing another sheet.

Essentially, I need a Count of if the items meet the following criteria:

Were created in X Month (text column)

Were created in X Year (text column)

AND a multi-select column contains "North America"

I have my formula partially down, but it is only counting rows that ONLY contain North America in the {Cielo RPA Client Catalog - Region} column. I need it to include rows that might contain "North America" and other regions as well.

I tried adding in CONTAINS and HAS functions, but I am struggling getting those to work without either #UNPARSEABLE or #INCORRECT DATA SET issues.

Here is the formula that I have currently:

=COUNTIFS({RPA Client Catalog Month}, "January", {RPA Client Catalog - Year Bot WL}, "2023", {RPA Client Catalog - Region}, "North America")

Find more posts tagged with

Accepted answers

Darren Mullen

@Jessica Z How were you using the HAS function?

Try this:

=COUNTIFS({RPA Client Catalog Month}, "January", {RPA Client Catalog - Year Bot WL}, "2023", {RPA Client Catalog - Region}, has(@cell, "North America"))

All comments

Darren Mullen

@Jessica Z How were you using the HAS function?

Try this:

=COUNTIFS({RPA Client Catalog Month}, "January", {RPA Client Catalog - Year Bot WL}, "2023", {RPA Client Catalog - Region}, has(@cell, "North America"))

Jessica Z

https://community.smartsheet.com/discussion/comment/392237#Comment_392237

Thanks so much Darren! This worked - I was not using the @cell in the formula, so that was my issue. Appreciate the help!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.