countIF a value column if the attribute is along side another attribute in a "Multi select Column"

Does anybody know if you can create a formula that will count the values in a “dropdown (Multi-Select) column", when adding summary fields on a Smartsheet list?

What is happening now is, if I have Apple and Orange in one field and I want a count for Apple. it will not count it. Only if I have Apple along in a field?

If I am counting how many time the word apple is in a column I want it to count it if it is alone or if it is along side another selection in that some cell.

Find more posts tagged with

Formulas

Accepted answers

Danielle O'Connell

You can use the CONTAINS function in your formula to get a count. Example:

=COUNTIFS([Column1]:[Column1], CONTAINS("Apple", @cell))

That would give you the total number of cells that have Apple in it. If you want a distinct count for when Apple is alone use this:

=COUNTIFS([Column1]:[Column1], "Apple")

If you want a count of Apple + something else, this would work but it is cumbersome if you have a lot of potential pairings:

=COUNTIFS([Column1]:[Column1], AND(CONTAINS("Apple", @cell), CONTAINS("Orange", @cell))

All comments

Danielle O'Connell

You can use the CONTAINS function in your formula to get a count. Example:

=COUNTIFS([Column1]:[Column1], CONTAINS("Apple", @cell))

That would give you the total number of cells that have Apple in it. If you want a distinct count for when Apple is alone use this:

=COUNTIFS([Column1]:[Column1], "Apple")

If you want a count of Apple + something else, this would work but it is cumbersome if you have a lot of potential pairings:

=COUNTIFS([Column1]:[Column1], AND(CONTAINS("Apple", @cell), CONTAINS("Orange", @cell))

David Wentworth

Thank you, that did the trick! :-)

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.