Count distinct with criterion

Kelsey Kilbury

Hello,

I'm trying to count the number of projects we have that are in the Draft state. I can't seem to get the correct combination of COUNT, DISTINCT and IF together into a formula to yield the results that I want. Has anyone been able to achieve this? Here is a screenshot of the columns that I'm trying to reference:

Paul Newcome

You want to try a COUNT/DISTINT/COLLECT

=COUNT(DISTINCT(COLLECT([Project ID]:[Project ID], [Opportunity State Name]:[Opportunity State Name], @cell = "Draft")))

Paul Newcome

You want to try a COUNT/DISTINT/COLLECT

=COUNT(DISTINCT(COLLECT([Project ID]:[Project ID], [Opportunity State Name]:[Opportunity State Name], @cell = "Draft")))

Kelsey Kilbury

@Paul Newcome the COLLECT function escaped my consciousness. Genius! Thank you.

Paul Newcome

Happy to help. 👍️