Countif on column with multiple answers


So I am creating a dashboard to calculate how many times a certain answer is given for a question on a form. On the form, they can answer things like teamwork, culture, quality, recruitment, communication, etc. but they can also select more than one answer in this column, and I think that is throwing my formula off.

I used initially =countif (positive highlights, "teamwork") and got a 0, where it should be a 1. The only answer right now is teamwork but they also selected culture, quality and recruitment so I think that is messing my answer up. What formula can I use for this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!