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

Justin326326

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

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", "")))