Help on formula countifs with contains referencing another smartsheet
I have tried this formula numerous ways this morning and I am clearly not formatting this correctly and could use your help.
I am trying to create a formula in a sheet that is gathering counts from 2 other sheets. Eventually I will need to add in some other criteria but I am having trouble getting the syntax correct for a simple countifs with a contains statement.
I am looking for text in a multi select drop down column that I have create a reference for.
Here is the base formula I am trying to get right before adding in other criteria. Once I get the entire Countifs to work I will copy the formula adding a +countifs that references the second smartsheet. I hope that makes sense.
Here's the formula that I have tried in numerous ways this morning:
=COUNTIFS({M2School}, CONTAINS("Sam Fox School of Design & Visual Arts"))
Returns Incorrect argument
I am using contains because the School column in the sheets might have Sam Fox School of Design & Visual Arts and another School.
If you could help with this syntax then I think I can add the additional criteria.
Answers
-
=COUNTIFS({M2School}, CONTAINS("Sam Fox School of Design & Visual Arts",@cell))
Add
@cell
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!