COUNTIFS where one criteria includes HAS
Good morning, Community! I could use some help with a formula. The yellow below should return a count from the **CBO CBA Case Tracker where (1) CPA Provided includes the CBA Provided sheet and column for that cell AND (2) if the CBA Provided Phase column on the **CBO Case Tracker sheet is Phase 1. I'll copy and update the Phase 2 column on the CBA Provided sheet. I thought that because the CBA Provided column on the **CBO CBA Case Tracker was a multi-select, HAS was the appropriate choice....but when I add that criteria to the formula, that's where the invalid operation comes in.
I could really use an assist here, please :).
Best Answer
-
@Chris Hallo HAS requires 2 arguments https://help.smartsheet.com/function/has#:~:text=The%20HAS%20function%20is%20designed,select%20or%20multi%2Dcontact%20cell.
In your case the range would be @cell . Here's a video on @cell if you aren't familiar https://youtu.be/KchiWBgsv4A
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@Chris Hallo HAS requires 2 arguments https://help.smartsheet.com/function/has#:~:text=The%20HAS%20function%20is%20designed,select%20or%20multi%2Dcontact%20cell.
In your case the range would be @cell . Here's a video on @cell if you aren't familiar https://youtu.be/KchiWBgsv4A
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thanks, @Darren Mullen!
-
@Chris Hallo you're welcome!
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
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
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!