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


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!