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

Stefania

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

Stefania

Paul Newcome

Try changing your delimiter to CHAR(10) instead of a space.

Paul Newcome

Try changing your delimiter to CHAR(10) instead of a space.

Stefania

It worked! Thanks a lot!

Paul Newcome

Happy to help. 👍️