COUNTIFS for assigned to CONTAINING a name

vanessa Williams

I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0

=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed")

Anyone help!?

L_123

Do you allow for multiple contacts in each cell? If not the formula below will work.

=COUNTIFS( [Assigned To]:[Assigned To], "Vanessa Williams", Status:Status, <>"completed")

L_123

If there are potentially multiple contacts in the individual cell you can use this trick:

=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("Vanessa Williams", join(@cell)), Status:Status, <>"completed")

vanessa Williams

Yes, I need to allow for multiple contact and count accordingly, even if more than one contact is selected.

L_123

I have posted a second formula above in the case that there is a requirement for multiple contacts.

vanessa Williams

I wasn't able to get that to work, but this ended up working well:

=COUNTIFS([Primary (Assigned To)]:[Primary (Assigned To)], FIND("vanessa", @cell) > 0, Status:Status, <>"completed")

Lester G Kelly

https://community.smartsheet.com/discussion/comment/249885#Comment_249885

CONTAINS doesn't seem to work for the "Assigned To" Column but find does.