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

Options
bbemis
bbemis ✭✭✭
edited 12/09/19 in Formulas and Functions

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!

Tags:

Comments

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    Options

    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


    ✅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!

  • bbemis
    bbemis ✭✭✭
    Options

    Thank you!!  This worked!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!