Join Unique Children Values


One of my columns is "Item Type", which classifies the type of product within the parent project. All of the children items include the item type, so I'd like for the parent row to join those values. There are only four different types; however several children might be the same type. I'd like for the parent row to join all of the unique types.

Item Types: Box, Pipe, Rebar, SET

If there are five children with Box, and two children with Rebar, I want the result to be Box, Rebar.

Is it possible to join only the unique values for the children?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!