COUNTIF, Cross Sheet, Multiple Contacts

Jessica Griffin
Jessica Griffin ✭✭✭✭
edited 09/21/21 in Formulas and Functions

I am counting the number of times a contact is referenced in the Assigned column, cross sheet. There can be multiple contacts listed on each row but I am just looking for a total count of the number of times an individual is listed.

This is the formula I have, but returns unparseable.

=COUNTIF({Internal Comms Intake Range 1} HAS(@cell, "Amy Merck"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!