Returning Matching String Values Once
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})
Answers
-
sorry I read that wrong. Let me change my answer.
Does using =join(distinct(collect( work for what you're doing?
-
=JOIN(DISTINCT(COLLECT(collectrange, criterion_range1, criterion1, criterion_range2, criterion2)), ", ")
-
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....
-
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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!