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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!