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.
Tags:
Answers
-
Try something like this (assuming the count is on a different sheet):
=COUNTIFS({Contact List Column}, HAS(@cell, "Janice Doe"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!