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
Check out the Formula Handbook template!