Help with DISTINCT Formula

Tricia Banks
Tricia Banks ✭✭
edited 12/09/20 in Formulas and Functions

I need to calculate a value that shows the following:

# of distinct institutions in a column, and out of those distinct institutions, I need to filter out the Global institutions in another column labeled "Territory". Here is what I have come up with, but it is not working:

=COUNTIF(DISTINCT(Institution:Institution), Territory:Territory, NOT(@cell = "Global"))

I saw somewhere that the COUNTIF and COUNTIFS do not work with the DISTINCT value. Is that true? Help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!