I am trying to use COUNTIF to count a certain word (from a multi-select dropdown) in a column


The formula I tried to use isn't working to read what I need it to...

Using =COUNTIF({Q1 - Strengths}, "Accountability") hasn't done it correctly.

I used =COUNTM({Q1 - Strengths}, "Accountability") but it counts everything in column, not only the word/title I need it to.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!