Count Distinct Formula



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 :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!