Summarizing Text from Children

Options

I have a hierarchy set up and want the parent line to automatically pick up all text in the same column as the children, ideally unique/distinct values only.

For example, my children are

"SEA

Singapore"

"SEA

Vietnam"

"Indonesia

SEA"

Thailand

Which are all items selected from a drop-down menu

I want the formula to return SEA Singapore Vietnam Indonesia Thailand. Is there any way to do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!