Formula to count all instances of a value in specific column from another sheet

I am trying to create a formula that references another sheet and totals the number of times a specific value shows up in a column that allows multiple values (from a dropdown menu). I am using =COUNTIFS({insert reference to column on other sheet}, HAS(@cell, "insert specific value")), but it only counts the number of times my specific value shows up as the only value in the cell, not when it is one of 2 or more selections. What am I doing wrong?

Find more posts tagged with

Formulas

Accepted answers

All comments

AravindGP

Hi @SKW

HAS in Smartsheet looks for an exact match, i.e., only that specific value. Replace it with CONTAINS and you should get the result.

=COUNTIFS({insert reference to column on other sheet}, CONTAINS("insert specific value", @cell))

SKW

thank you!

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.