Use DISTINCT with COUNTIFS

@khush_hello@khush_hello ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
07/31/19 Edited 12/09/19

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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)

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Yes. You would actually need to use

     

    =COUNT(DISTINCT(COLLECT(.........................................................)))

Sign In or Register to comment.