Is there a CONTAINS alternative for Contact formatted cells?

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!