Returning Matching String Values Once

otavilog ✭✭✭✭

10/27/22 in Formulas and Functions

I have a {Client} row in an external sheet. Certain client name can appear multiple times. I am trying to have it listed once .

I tried DISTINC, MATCH and no luck.

=DISTINC({Client})

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Answers

• 

  Michael Culley ✭✭✭✭✭

  10/27/22 edited 10/27/22

  sorry I read that wrong. Let me change my answer.

  
  

  Does using =join(distinct(collect( work for what you're doing?

  0 · Share on FacebookShare on Twitter
• 

  Michael Culley ✭✭✭✭✭

  10/27/22

  =JOIN(DISTINCT(COLLECT(collectrange, criterion_range1, criterion1, criterion_range2, criterion2)), ", ")

  0 · Share on FacebookShare on Twitter
• 

  otavilog ✭✭✭✭

  10/27/22 edited 10/27/22

  @Michael Culley

  Thank you. I realize I wasn't very clear.

  This is what I have:

  

  
  

  I get with your formula:

  

  
  

  What I am trying to achieve:

  

  
  

  Not sure if it is even possible....

  0 · Share on FacebookShare on Twitter
• 

  otavilog ✭✭✭✭

  10/27/22

  @Michael Culley

  
  

  Solved it: I applied this formula:

  =IFERROR(INDEX(DISTINCT({Client}), [Row ID]@row, 1), "")

  Only works if you add an additional column with numbers assigned. This is what the result looks like:

  

  
  

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list