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
- Smartsheet Customer Resources
- 62.2K Get Help
- 359 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!