Counting the number of unique contacts in multi-select contact column for a specific date
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)
Help Article Resources
Check out the Formula Handbook template!