Counting the number of unique contacts in multi-select contact column for a specific date

Options
Raquel Love
Raquel Love ✭✭✭
edited 10/19/23 in Formulas and Functions

I'm looking for a formula that would be able to count the number of unique contacts that are in a contact column that match a specific date. I have a multi-select contact column that has the names of people that are attending meetings throughout the week, and I want to be able to see how many unique attendees will be attending meetings on any given day (some of the meetings have the same people attending them, so I can't use a straight count of the names within the multi-select contact column as their names will show up multiple times).

I know this isn't the formula, but looking for what the right formula would be:

=COUNTM(DISTINCT([Meeting Attendees]:[Meeting Attendees], [Meeting Date]:[Meeting Date], =DATE(2023, 11, 2)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!