COUNTIFS for assigned to CONTAINING a name

I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0

=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed")

Anyone help!?

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

L_123

Do you allow for multiple contacts in each cell? If not the formula below will work.

=COUNTIFS( [Assigned To]:[Assigned To], "Vanessa Williams", Status:Status, <>"completed")

L_123

If there are potentially multiple contacts in the individual cell you can use this trick:

=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("Vanessa Williams", join(@cell)), Status:Status, <>"completed")

vanessa Williams

Yes, I need to allow for multiple contact and count accordingly, even if more than one contact is selected.

L_123

I have posted a second formula above in the case that there is a requirement for multiple contacts.

vanessa Williams

I wasn't able to get that to work, but this ended up working well:

=COUNTIFS([Primary (Assigned To)]:[Primary (Assigned To)], FIND("vanessa", @cell) > 0, Status:Status, <>"completed")

Lester G Kelly

https://community.smartsheet.com/discussion/comment/249885#Comment_249885

CONTAINS doesn't seem to work for the "Assigned To" Column but find does.

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.