Is there a CONTAINS alternative for Contact formatted cells?

J Mosher

Goal: Count the number of times a name is mentioned.

Assigned to is multiple contact column

Name is a contact column

=COUNTIFS({P & A - Assignments List | Assigned To}, CONTAINS([Name]@row, @cell))

Is there a CONTAINS alternative for Contact formatted cells?

Carson Penticuff

Yes, you are looking for the HAS() function.

https://help.smartsheet.com/function/has

=COUNTIFS({P & A - Assignments List | Assigned To}, HAS(@cell, [Name]@row))

Paul Newcome

The HAS function works for contact type data when you are looking for an exact match. If you are looking for a partial match (such as just last name or something like that), you would use the FIND function.

https://help.smartsheet.com/function/has

https://help.smartsheet.com/function/find

.