Count Distinct Formula
Hello,
I have a sheet with over 200 cells of duplicate reference numbers and would like to only pull unique values from the column Req # and only if they are open reqs.
I am trying to create a simplified sheet that references/pulls in list of unique "open" Req Numbers
=IFERROR(DISTINCT(COLLECT({Dump: OPEN AND CLOSED REQS Range Req #}), " ")) but it is pulling as an incorrect argument.
I am pretty new to smartsheet. Thank you for all of your help :)
Answers
-
I have also tried doing something like this where I try to get it to only return if the req # is open
=INDEX(DISTINCT(COLLECT({Dump: OPEN AND CLOSED REQS Range Req #}, {Dump: OPEN AND CLOSED REQS Range Req #} {Dump: OPEN AND CLOSED REQS Range 2}, "Open")))
-
You would need a COUNT/DISTINCT/COLLECT.
=COUNT(DISTINCT(COLLECT({Range To Count Distinct Values In}, {First Criteria Range}, first_criteria, {Second Criteria Range}, second_criteria, …………………)))
-
How would I be able to format this I am having issues creating the formatting for this
-
It would be formatted the way it is formatted in my above example.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!