COUNTIF Multiple Select Row

I am trying to count all of the instances One Value is showing up in the assigned row even if two people are assigned to the same row. This is the equation I came up with but I keep getting zero even though there is actually one with that value combined with another value. What am I doing wrong?

=COUNTIFS({Project Oversight Range 5}, (CONTAINS("Mike Buckiewicz", @cell)))

A variation of this equation worked to count if there was one selection only in the column but is not calculating when there are multiple.

Please help!

Find more posts tagged with

Accepted answers

Charlotte Loison-Jimenez

You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:

=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))

https://help.smartsheet.com/function/has?_ga=2.1631090.234980845.1615223151-1183548819.1604442814

All comments

Charlotte Loison-Jimenez

You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:

=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))

https://help.smartsheet.com/function/has?_ga=2.1631090.234980845.1615223151-1183548819.1604442814

Mike Buckiewicz

Yes this is it! I am still learning functions so will add HAS to my arsenal!

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.