How do I handle tracking metrics when a task has been assigned to two names?

Just on a basic level, my Assigned to column at times has multiple names - I have enabled multiple contacts.

The issue comes when I collate metrics (summing them) in another sheet where I am pulling numbers based on who the task was assigned to.

So, lets say I have Jack and Jill while their values would collate, if a task was assigned to both Jack and Jill, it would not collate their hours for both of them but just detect it as a whole different entity

I presume one workaround I could have is to actually collate Jack and Jill in my other sheet and just add the value to their respective sums

Find more posts tagged with

Accepted answers

All comments

Justin326326

The solution I came with would not work as in these examples sometimes its jack and jill other times its jack jill and joseph, so I would have to account for too many possible "contacts"

Paul Newcome

Are you able to provide some screenshots for context? Generally speaking, you should incorporate a HAS function when dealing with multi-select column types.

=COUNTIFS({Range}, HAS(@cell, "Jack"))

Justin326326

I think I have it working, this method is a bit more convuluted but I've just created a helper column, so if I have a calculation for Joe for example I'd just get Joe's values + Both

=IF(AND(FIND("Joe", [Assigned To]@row) > 0, FIND("Pete", [Assigned To]@row) > 0), "Both", IF(FIND("Joe ", [Assigned To]@row) > 0, "Joe", IF(FIND("Pete", [Assigned To]@row) > 0, "Pete", "")))

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.