Multiple contacts in one cell count

Hello,

I am looking to count a specific contact within a cell that has multiple contacts but I would also like to ensure the count is for a specific criteria. For example

Joe Smith and Jane Doe are in the same cell but I want to count how many times Joe smith appears in the smartsheet while also ensuring he is meeting an additional criteria in another column as "in progress".

I am trying countif function with a find function but am having no luck.

any assistance would be greatly appreciated.

Find more posts tagged with

Accepted answers

All comments

Kelly Drake

Try COUNTIFS + CONTAINS.

= COUNTIFS([status range], "in progress", [Range of contact column], CONTAINS("Joe Smith", @cell)

Adam Joe

with respect to the @cell, I am referencing another sheet would this have any implications?

Also if I wanted to build in an additional layer around complexity would this be possible?

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.