Counting Multiple Values in One Cell


We have a form with a multi-select option for "Event Type". I am trying to create a new sheet that can be used within a dashboard with a chart that shows how many "Event Types" there are within a given "Delivery Format". Snippet of sheet collecting form submissions below. The formula I was using to try and find the number of event types is as follows:

=COUNTIFS({Field Events - Simple Event Range 2}, "Hybrid", {Field Events - Primary Sheet Range 1}, HAS({Field Events - Primary Sheet Range 1}, "Roadshow"))

However, it keeps coming back as "0". As you can see from the primary sheet snippet, it should come back as 1 since there is one hybrid delivery format with an event type of roadshow.

What am I doing wrong in the formula?

Thanks for your help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!