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
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 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!