Countif with dropdown multiselect colum
I have a dropdown multiselect column with about 10 dropdown options from which to choose. So obviously I can choose more than one option in each cell! I'm trying to create a chart for my dashboard that shows how often each of the 10 options is chosen. So I've created a countif equation for each of the 10 dropdown options which references the dropdown multiselect column. It's working really well when there is only ONE option in a cell, but if I have more than one (since it's multiselect, I often do!), then the countif equation is not picking it up. Is there a way around that? Thank you!
Answers

Use "Contains" in your formula:
=COUNTIF(MultiSelect:MultiSelect, CONTAINS(Option@row, @cell))

Thank you! My formula is a bit different (obviously wrong!) and doesn't work if I put CONTAINS in it.
=COUNTIF({CDHE Consultation Program Range 5}, "SOGI"). This formula populated when I chose COUNTIF from the advanced options in the formula dropdown. I just chose which sheet to reference and put in "SOGI".
CDHE Consultation Program is the Sheet I'm referencing. Range 5 must be the column. "SOGI" is the value I want it to contain. Would you be able to send me the correct formula with COUNTIF & CONTAINS?
Thank you.

Hi @Maggie Lackey ,
Try this:
=COUNTIF({CDHE Consultation Program Range 5}, CONTAINS("SOGI", @cell))
Best,
Heather

Yes! I did actually figure that out earlier. It's perfect and I'm really excited!
Thanks!

I am having a similiar problem and the CONTAINS function did not fix the problem.
I am trying to get a count of the number of tasks assigned to myself "Valerie" within a multiselect drop down that are not done (aka false in checkbox column).
Here is what I have so far. I have tried multiple different formula variations and cannot get it to work. I have a filter which works perfectly, so I know the count I am looking for, but it keeps returning a count of 0.

Hi Valerie,
This is a shot in the dark, but try this:
=COUNTIFS([action item assigned to:]:[action item assigned to:], CONTAINS("Valerie", @cell), [action item done:]:[action item done:],0)
Let me know if it works!
Best,
Heather
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!