I am trying to count how many times a word is picked in multi dropdown menu

So i have a single column with a multi drop down box. The reason for this is to select multiple options in certain circumstances. When i use =COUNTIF(Classification:Classification, "text") it will count if only one option is picked but once more than one of the selections is picked it will only count 1 of the 2.

when i use =contains it comes back as not possible.

for example ;

if i have multiple names down one row and in the next a multiselect dropbox of favourite colours and people can choose more than one, what formula will allow me to pick every time red is picked in that column ?

TIA

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!