Join / Collect formula

aecross

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.

NicoLHC

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), ", ")