Countifs function when using multiple contacts in a cell

Sarah_lee

Hello,

I am trying to run metrics on assigned tasks that are assigned to people on my team.

I have reports that will pull into each person's task report even with multiple assigned contacts in a cell, but when I do COUNTIF for a specific person's task, it does not count because there are multiple contacts in a cell.

current formula is =COUNTIFS({Assigned To}, [Primary Column]@row), where [Primary Column]@row = the persons name.

Problems is that she has 2 tasks, however one of them is in conjunction with 2 other names in the contact field so it only counts 1 task instead of both tasks.

Is there a different formula that will count her task if her name is one of three names in the contact column?

Thanks in advance

Sarah

Paul Newcome

You will need to incorporate a HAS function.

=COUNTIFS({Assigned To}, HAS(@cell, [Primary Column]@row))

Paul Newcome

You will need to incorporate a HAS function.

=COUNTIFS({Assigned To}, HAS(@cell, [Primary Column]@row))

Sarah_lee

@Paul Newcome

You're amazing, thanks!

Paul Newcome

Happy to help. 👍️