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

Hello,

New to Smartsheet.gov 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!

Margie

Find more posts tagged with

Accepted answers

Paul Newcome

It would be the same way that you used it on the Country Range.

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

All comments

Paul Newcome

It looks like your FIND function is only looking at the countries. If your Events Attended column is a multi-select, then you may want to use a FIND function on that criteria as well.

Marjorie Splattstoesser

Thanks Paul. I'm not exactly sure what that would look like. Can you show what that would look like?

Paul Newcome

It would be the same way that you used it on the Country Range.

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

Marjorie Splattstoesser

This worked! Thank you so much!

Paul Newcome

Happy to help! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.