Join & Collect Children: 1 Occurrence

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!