COUNTIFS Question

I have a smartsheet with MANY columns; I need to do a countif based on 3 of them. This portion works:
=COUNTIFS({Quarter Created On}, "Q3", {GEO}, "AMERICAS")
When I try to add this, it all falls apart: {EA 2.0 Architecture Selection}, FIND("Collab")
I tried this just to see if I could get the right count of rows with Collab in them; I get 0 - I'm guessing that could be because this is not referencing the whole column?
=COUNTIF({2H FY22 Cross Arch SPIFF Team Registrati Range 11}, HAS(@cell, "Collab"))This column is a multi select and will have a variety of entries.
Any guidance would be greatly appreciated.
Thanks,
Lisa
Answers
-
Have you tried using the CONTAINS function with that third criterion set?
-
Yes. That did not help. But with some help from an associate, this is what he came up with and it works: =COUNTIFS({Quarter Created On}, $[Column11]@row, {GEO}, [Column13]@row, {2H FY22 Cross Arch SPIFF Team Registrati Range 11}, HAS(@cell, $[Column7]@row))
This eliminates the hard coding that I had above which is always a good idea.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!