Countifs function when using multiple contacts in a cell

Options

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!