Need help with Distinct Count with multiple filters please!

Hi All! I'm trying to figure out how to build a formula to track how many clients still have outstanding issues on a different sheet.

I have a basic count of outstanding tasks.

=COUNTIFS({Reference Sheet}, "Outstanding Task")

When I tried to add Distinct to this, it understandably changed my total to 1.

=COUNTIFS({Reference Sheet},DISTINCT({Reference Sheet Tier-Client Number} "Outstanding Task"))

Could someone please take a look? I saw someone used Collect on another formula, but I'm not sure if I'd have collect the different pieces separately?

Thank you!



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭


    =Distinct(Collect({Reference Sheet Tier-Client Number}, {Reference Sheet}, @cell="Outstanding Task"))



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Thank you for taking a look Mark! It gives me an invalid ref, question for the piece (Reference Sheet}, @cell="Outstanding Task")), do I need to select which column to pull that data from that is part of the prior range as well?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!