How do I Count the rows on a "Contact List" column, for the current user?


Example: I list team members in a Contact List by project. Team members range from 0 to 5 team members:

Goal: count each team member's occurrences on 3 projects. Art Jones, Janice Doe, Terry Tonsil, Mary Green.

Project Team Members (Contact list)

Market Art Jones, Janice Doe.

Inventory Terry Tonsil, Janice Doe, Mary Green.

Party Art Jones, Janice Doe,

I'd like an answer 😀 of: 3 Janice Doe, 2 Art jones, 1 Terry Tonsil, 1 Mary Green.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!