COUNTIF in Muti-Select Column
Good morning, I am trying to count how many times a name appears in a multiselect column, the problem is that when there is more than one name in the column it will not count it. Here's my formula so far
=COUNTIFS({Construction Damage & Complaint Tracker Range 1}, "Gary"
Although Gary's name should count 5 times, it does not because there are other names in that column as well.
Any help would be appreciated!
Best Answer
-
=COUNTIF({Construction Damage & Complaint Tracker Range 1}, HAS(@cell, "Gary"))
However, HAS function needs to find an exact match. So as long as its just Gary and doesn't include a last name that should work.
If it includes a last name you can use:
=COUNTIF({Construction Damage & Complaint Tracker Range 1}, CONTAINS("Gary", @cell))
Answers
-
=COUNTIF({Construction Damage & Complaint Tracker Range 1}, HAS(@cell, "Gary"))
However, HAS function needs to find an exact match. So as long as its just Gary and doesn't include a last name that should work.
If it includes a last name you can use:
=COUNTIF({Construction Damage & Complaint Tracker Range 1}, CONTAINS("Gary", @cell))
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!