Formula for "Allow Multiple Contacts per Cell"

I have been tasked with creating a dashboard with some metrics on it. Below is an example of what I am looking to have created.

On one of my smartsheet columns is an "Assigned to" section. There are 3 people in that list.

Bob, Jan, and Jill.

Bob has 1 row assigned to him.

Jan has 1 row assigned to her.

Jill has 1 row assigned to her.

This is the formula I used to show me how many rows are assigned to each person. =COUNTIF({Test example range 1}, [Primary Column]@row).

The formula does the calculation and everyone has 1. Perfect.

The problem is there is a 4th row. On the 4th row, it is assigned to Bob, Jan, AND Jill.

So, my goal is to find a formula that would show that they each have 2 rows assigned to them, not 1.

Any help would be greatly appreciated.

Find more posts tagged with

Accepted answers

Kelly Moore

Hello @WesMcNally

Multiselect columns need the functions HAS, CONTAINS or FIND. Try this

=COUNTIFS({Test example range 1}, HAS(@cell,[Primary Column]@row))

Does this work for you?

Kelly

All comments

Kelly Moore

Hello @WesMcNally

Multiselect columns need the functions HAS, CONTAINS or FIND. Try this

=COUNTIFS({Test example range 1}, HAS(@cell,[Primary Column]@row))

Does this work for you?

Kelly

WesMcNally

That did the trick! 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.