How do I extract the values from a multi-select dropdown?

bbemis

I am trying to count values from multi-select dropdown. 

We asked how many check-ins 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!

Frank Falco

Try this:

=COUNTIF(Multi:Multi, CONTAINS("4/year", @cell))

Where Multi is the multi-select column

You could replace "4/year" with any of the six values or cell/@row reference

Hope that gives you what you need