Countifs function when using multiple contacts in a cell



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



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!