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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!