How to make parents equal to the children list in a drop down menu


Hi everyone,

I have been struggling for a while with this formula.

I'm trying to have the parents populated automatically to be equal to the list of children in a drop down menu, without repetition if the same instance is repeated twice in the children.

In the picture below I'm trying with =JOIN(DISTINCT(CHILDREN()), " "). However it is not giving the output that I want: If there are sub-parents, the join function creates duplicates. The parent in the example contains ASE repeated twice.

Do you have any suggestion on how to make this?

Thank you



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!