COUNTIF with multiple select dropdown column

Options
Del Horne
Del Horne ✭✭✭✭

Hi,

This has me going mad! 🤬🤣

I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet.

This is counting fine where the dropdown has "C" and "E" selected:

=COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E")

However, when "iP" and "S" are selected the COUNTIF returns 0 which I know is not the case:

=COUNTIF({Business Area}, @cell = "iP" + CHAR(10) + "S")

If I count the "iP" and "S" separately all is fine, it's only when I try to count as combined selected values...

Any thoughts please?

Thanks!

Del

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!