Using FIND within a COUNTIFS formula and a Multi-Select Column


New to and I'm having an issue.

My data sheet has a column with events attended. It's a multi-select dropdown. Each participant is tagged with the events they have attended. I have a tally sheet by country to count how many participants have attended each event. The formula below is pulling correct information for some, but is omitting some events for others.

=COUNTIFS({Countries}, FIND($[Primary Column]@row, @cell) > 0, {Events attended}, [EVENT NAME]$1)

(Event name is made generic for security purposes)

This is my roll-up tally sheet.

This is my data sheet that I'm pulling from. It has the multi-select drop-down that I'm trying to tally.

Any suggestions would be appreciated.

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!