Join & Collect Children: 1 Occurrence

Anthony Barthelemy
Anthony Barthelemy âś­âś­âś­âś­âś­âś­

Smartsheet Community:

How can I modify this formula where it only Collect 1 Child Occurrence?

Existing Formula: =JOIN(COLLECT(CHILDREN(), CHILDREN(), <>""), ", ")

Children: Chrome, Chrome, Firefox, Safari, Safari

Thanks

Best Answer

  • Paul Newcome
    Paul Newcome âś­âś­âś­âś­âś­âś­
    Answer âś“

    That is because you have the delimiter set as part of the DISTINCT function. If we shift one of the closing parenthesis from the end, it should resolve the issue.


    =JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), ", ")

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!