Formula for counting unique orgnizations

Drea Mora

I'm working on a sheet that counts touchpoints with organizations around our region. Sometimes, we meet with the same organization multiple times a month. I'm hoping to write a formula that can count the number of unique agencies we collaborate with within a time range. We collect the organization (which is also the primary) and date of meeting. Can someone help me write this formula?

MPath

Would this topic help?

https://community.smartsheet.com/discussion/67424/formula-to-only-count-unique-cells-no-duplicates

Paul Newcome

You would use something along the lines of

=COUNT(DISTINCT(COLLECT({Organizations Column}, {Date Column}, date_criteria)))

MPath

Would this topic help?

https://community.smartsheet.com/discussion/67424/formula-to-only-count-unique-cells-no-duplicates

Paul Newcome

You would use something along the lines of

=COUNT(DISTINCT(COLLECT({Organizations Column}, {Date Column}, date_criteria)))

Drea Mora

Okay that worked thank you! What if I wanted to add another layer of filtering by "Type of Activity" is "Community engagement"? How would i add that layer? This is currently the formula that's pulling distinct organizations by date correctly (thank you!).

=COUNT(DISTINCT(COLLECT(Organizations:Organizations, Date:Date, AND(@cell >= DATE (2025, 3, 1), @cell <= DATE(2026, 8, 31)))))

Paul Newcome

You would add another range/criteria set to the COLLECT function.