Can I "count a specific person in an Assigned To column when there are multiple people in that cell?

steven.nienaber105336

I want to know how many tasks are assigned to a certain individual, but this individual is assigned to tasks that are also assigned to others as represented in the Assigned To column. The "Allow Multiple Contacts Per Cell" box checked. Is there a formula that will pull out only one of the names listed? i.e., 3 cells have my person listed; two of the 3 have another individual listed. I want the formula to state that my person has 3 tasks.

Kelly Moore

Hey

Try this

=COUNTIFS([Assigned To]:[Assigned To], HAS(@cell, "specific person"))

Change to the specific person name you need or use [Assigned To]@row (without any quotes) if all the names are in a list. When using a specific person you will need to be mindful whether smartsheet is listing the name as a Contact name, or an email address - write it exactly the way that smartsheet does

Kelly Moore

Hey

Try this

=COUNTIFS([Assigned To]:[Assigned To], HAS(@cell, "specific person"))

Change to the specific person name you need or use [Assigned To]@row (without any quotes) if all the names are in a list. When using a specific person you will need to be mindful whether smartsheet is listing the name as a Contact name, or an email address - write it exactly the way that smartsheet does

steven.nienaber105336

THANK YOU!! I never cease to be amazed - this worked!! Thanks for the HAS function! :)