Counting specific values in multi select cells

bea.sun ✭✭
edited 09/26/22 in Formulas and Functions

Hi All,

I am trying to count how many offices have certain engagements (choices are Calls, Email, Weekly PF call, FB gorup, Other, Texts). These cells are linked cells from another sheet.

I tried these formulas:

=countif([Office Engagement:Office Engagement], contains("Calls", Office Engagement@row))

=countif([Office Engagement:Office Engagement], find("Calls", Office Engagement@row))

=countif([Office Engagement:Office Engagement], has(Office Engagement@row, "Calls))

and they are pulling 0 even though the choice is in the cell. I've tried to add "> 0" at the end of the countif formula, but then it only pulls how many cells total that are not blank.

Please advise.

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!