How to count a singular thing in a multi-drop down response list

Hello, I'm trying to count a response to the question community services a patient receives, there are multiple different choices as you can see here to the left.

The problem that I'm having is when I'm trying to find the number of "Outpatient therapy" responses I'm only getting one. Here's my f-code.

=COUNTIF({SOC Wraparound Client Tracker Data Set Range 5}, "Outpatient Therapy")

I believe it's only giving me 1 because, there is one section where it is alone. How do I count it, even when there is another category included in a cell?

Thank you.

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @Matthew Manicke,

Try using CONTAINS:

=COUNTIF({SOC Wraparound Client Tracker Data Set Range 5}, CONTAINS("Outpatient Therapy",@cell))

Best,

Heather

Matthew Manicke

Hi @Heather D , so this is what I have now. =COUNTIF({SOC Wraparound Client Tracker Data Set Range 5}, CONTAINS("Outpatient Therapy", {SOC Wraparound Client Tracker Data Set Range 5}))

It gave me 0, which is incorrect.

I don't know what you mean by @cell I'm trying to have this for future entries so I don't want to just highlight the cells.

David Fiorino

Try this one:

=COUNTIF({SOC Wraparound Client Tracker Data Set Range 5}, CONTAINS("Outpatient Therapy", @cell))

Generally counting values in multi-select cells has been a problem. Maybe the updated syntax when they added column formulas fixed this using this call method. It is problematic when you have a large list of values... say the multi-select is a contact list and you have a large company.

Matthew Manicke

@David Fiorino Thank you that worked!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.