Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Use DISTINCT with COUNTIFS
Hey Guys!
I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!!
So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) i.e. IFS i.e. [Range1,Criteria1, Range2,Criteria2]
Refer below a sample of that formalue:
[=COUNTIFS({Owner}, [Primary Column]@row, DISTINCT({ProjectNumber}), <>0)]
But it is resulting: [#INCORRECT ARGUMENT SET]
Any advise would really be helpful!
Thanks!
Khushboo
Comments
-
Because SS is currently down, I cannot fully test, but try something like this instead...
=COUNTIFS({Owner}, [Primary Column]@row, {ProjectNumber}, DISTINCT(@cell) <> 0)
-
Hey any update on this? I'm trying to accomplish something similar:
=COUNTIFS({Resource Allocation View Range 4}, "Leader Capability", DISTINCT({Resource Allocation View Range 8}), <>0)
-
Yes. You would actually need to use
=COUNT(DISTINCT(COLLECT(.........................................................)))
-
@Paul Newcome How would you do this if you wanted to find distinct/unique values from multiple columns?
-
@Vivian Li Are you able to provide more detail/context and possibly some screenshots?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm curious for some inspiration please! I'm using a form to log usage of machinery. This collects data on the time used in minutes, which I convert to hours and total for each machine. The machines n…
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…