Join Unique Children Values

Azure.Sessums

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!

Darren Mullen

@Azure.Sessums It should work to use JOIN(DISTINCT(COLLECT())) .

Here is the DISTINCT function, it returns the distinct values from a range.

https://help.smartsheet.com/function/distinct

Darren Mullen

@Azure.Sessums It should work to use JOIN(DISTINCT(COLLECT())) .

Here is the DISTINCT function, it returns the distinct values from a range.

https://help.smartsheet.com/function/distinct

Azure.Sessums

@Darren Mullen Thank you so much, this did exactly what I needed it to do!