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")
Best Answer
-
@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"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@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"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thanks so much Darren! This worked - I was not using the @cell in the formula, so that was my issue. Appreciate the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!