For our projects, one column is "location". The "location" of the parent row is just a simple =join(children()).
However, we have locations that are merged into a cluster. For example, if a project is located in Singapore, the Philippines and Vietnam, it's in SEA.
Basically, what I want is a function that, if I have
Japan Philippines Vietnam Singapore Thailand
In the children cells, returns
In the parent cell
Is this possible or should I just give up and do it manually?
