Summarizing Text from Children

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?

Find more posts tagged with

Project Management

Accepted answers

All comments

Paul Newcome

Try something like this...

=JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), @cell <> "")), " ")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.