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!

Ashley

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Try:

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

Work?

Mark

asimcock

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.