How do I extract the values from a multiselect dropdown?
I am trying to count values from multiselect dropdown.
We asked how many checkins people would like to have: 1/year, 2x/year, 4x/year, etc. (a total of 6 options). When I did my counts, rows with more than one selection weren't counted. For instance, someone chose 2x/year and 4x/year. However, when I use the formula below, I get back 0.
=COUNTIF([Check Ins I]@row, "2x/year")
How do I count specific individual values, or get the value itself? The new "HAS" formula only pulls the number of values, not the specific value.
Thanks!
Comments

Try this:
=COUNTIF(Multi:Multi, CONTAINS("4/year", @cell))
Where Multi is the multiselect column
You could replace "4/year" with any of the six values or cell/@row reference
Hope that gives you what you need
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Thank you!! This worked!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!