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.
Answers
-
Try something like this (assuming the count is on a different sheet):
=COUNTIFS({Contact List Column}, HAS(@cell, "Janice Doe"))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!