Sheet Summary CountIfs with Multi-contact fields

Hi,

Is it possible to use a countIfs in a Sheet Summary referencing multi-contact fields? I would like to count the number of instance "Employee X" is in the responsible field column. However, i can't seem to get it to work. I tried using both Has and Contains function in conjuction with countIfs and no luck!

Has Formula

=COUNTIFS([Responsible:]:[Responsible:], Has([Responsible:]:[Responsible:], "Employee X"), [End Date]:[End Date], <>"")

=COUNTIFS([Responsible:]:[Responsible:], HAS(@row, "Employee X"), [End Date]:[End Date], <>"")-Resulted in Unparseable

Contains Formula

=COUNTIFS([Responsible:]:[Responsible:], CONTAINS("Employee X ", [Responsible:]:[Responsible:]), [End Date]:[End Date], <>"")

I found a similar question, but i wasn't able to get it to work for me

https://community.smartsheet.com/discussion/73687/multiple-select-contact-column-sheet-summary

Find more posts tagged with

Sheet Summary

Accepted answers

Mark Cronk

Try:

=COUNTIFS([Responsible]:[Responsible], Has(@cell, "Employee X"), [End Date]:[End Date], ISDATE(@cell))

Mark

All comments

Mark Cronk

Try:

=COUNTIFS([Responsible]:[Responsible], Has(@cell, "Employee X"), [End Date]:[End Date], ISDATE(@cell))

Mark

Quentin Rhodes

Thanks Mark for the quick response. I got so fed up i closed the app and was going to try again tomorrow. But, your quick and correct response got me going again. Thanks!!!

Mark Cronk

I noticed misplaced : in my 1st response. Edited and correct now. Should work. Good luck. Never give up.

Mark

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.