Count dropdown selections in one cell

I'm looking to see how I can add another FIND item to the below formula. Range 6 is a dropdown list and I'm looking to count all entries that have Global AND Mexico in the cell.

The below entry works for just finding anything with Global but I need it to also add anything that also contains Mexico in the same cell:

=COUNTIFS({Go-Live Incident Tracker Range 7}, "1", {Go-Live Incident Tracker Range 6}, FIND("Global", @cell) > 0)

Thanks

Angela

Find more posts tagged with

Accepted answers

All comments

Will.Parente

Have you tried just making those conditions what the COUNTIFS looks for?

=COUNTIFS({Go-Live Incident Tracker Range 7}, "Global", {Go-Live Incident Tracker Range 7}, "Mexico")

Let me know if this works!

Angela Logie

Will,

Unfortunately, this doesn't work, I think its to do with it being a dropdown column/cell. Its giving me a zero return, not an error message but thats not the correct answer.

Thanks

Will.Parente

Angela, no worries. Let's try using Contains Statements:

=IF(AND(CONTAINS("Global", WBS@row), CONTAINS("Mexico", WBS@row)), "1", "0")

https://help.smartsheet.com/function/has

Angela Logie

Will,

Unfortunately this does not seem to work. Its saying its #unparseable:

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.