Counting specific values in multi select cells

Options
bea.sun
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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!