Contains with Multi-select column

I have a column that is multi-select for our systems. The values in this column are X, Xi, S, SP and a few others. I am trying to count the number of rows where the value "X" is selected. Sometimes it may be only X, other times the column value may have both X and Xi. When i use contains, it is counting everything in the string, so it includes all the instances of Xi as well as X.

I've tried multiple approaches, but am stuck. Any help would be most appreciated. This was the original formula I tried.

=COUNTIF({Platform}, CONTAINS("X", @cell))

Find more posts tagged with

Accepted answers

Mike Wilday

This was tricky. Try this =COUNTIF({Platform}, IF(HAS(@cell, "X"), "true", "false") = "true")

This is essentially counting each cell and marking it as true if it contains exactly an "X"

All comments

Kelly Moore

Hi Lynn

Try HAS instead of CONTAINS. HAS is an exact match function. Note the syntax is different.

=COUNTIF({Platform}, HAS(@cell, "X"))

Mike Wilday

This was tricky. Try this =COUNTIF({Platform}, IF(HAS(@cell, "X"), "true", "false") = "true")

This is essentially counting each cell and marking it as true if it contains exactly an "X"

Lynn Meadow

Thank you so much for this suggestion. I had tried HAS, but Mike's answer below was spot on. Really appreciate you reviewing my question and reaching out!

Jason Duryea

Instead of using CONTAINS, try OR(@cell = "X", @cell = "Xi")

=COUNTIF({Platform}, OR(@cell = "X", @cell = "Xi"))

Lynn Meadow

thanks for responding, this was not quite what i needed, but Mike answered the question and that formula 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.