Join / Collect formula

Hi there -
Working on a formula to capture all people assigned in a column. Some contacts are duplicates. My formula is capturing all rows that Abby is assigned to, but I really just want to know if she is assigned at all. How can i adjust this formula to only capture Abby once, or will I need a helper column to do this? (and what would that look like…)
Formula:
=JOIN(COLLECT({TESTPlan.LeadDesigner}, {TESTPlan.ProjectID}, [Text/Number]15, {TESTPlan.LeadDesigner}, <>""), "; ")
Output:
Abby Smith; Abby Smith; Abby Smith; Abby Smith; Abby Smith; Abby Smith; Abby Smith; Abby Smith; Christina Johns; Christina Johns; Christina Johns;
Ideally, I would like this to just output Abby Smith; Christina Johns.
Answers
-
Hello @aecross did you try to use Smartsheet ai already? Feel free to visit our Webinar.
Please try this formula. If it dies not work share the sheet with me if you like nico.roepnack@lighthouseconsultings.com
=JOIN(COLLECT({TESTPlan.LeadDesigner},
{TESTPlan.LeadDesigner}, @cell = INDEX({TESTPlan.LeadDesigner}, MATCH(@cell, {TESTPlan.LeadDesigner}, 0)),
{TESTPlan.ProjectID}, [Text/Number]15), ", ")If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!