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

Okay try it this way:
=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0
I edited this back to FIND function.
Answers

You can use a formula like this that will count in a multi select column:
=COUNTIF(Answer:Answer, FIND("Teamwork", @cell) >= 1)
Need to adjust the "Answer" to either your column or your range or cross sheet reference.

That is saying unparsable when I try that.

Can you post your formula?

I have tried this as well and get a 0 here too where it should be 1:=COUNTIF({Positive Highlights}, CONTAINS("Teamwork", {Positive Highlights}))
I tried with yours: =COUNTIF({Positive Highlights}:{Positive Highlights}, FIND("Teamwork", {Positive Highlights}) > =1)

Okay try it this way:
=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0
I edited this back to FIND function.

This worked! Thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!