CHILDREN of two columns

I was trying to reference the children of two columns @row in a MIN(COLLECT()) function.

Currently, I am only able to use two separate COLLECT() ---

MIN(COLLECT(CHILDREN(col1@row, criteriaRange1, criteria1), COLLECT(CHILDREN(col2@row, criteriaRange1, criteria1))

But when I arrange the two columns together, MIN(COLLECT(CHILDREN(col1@row:col2@row), criteriaRange1, criteria1)), the result is #UNPARSEABLE.

Is there any way to make the formula shorter?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hey @CeliaC

Yes, you're right. You would need to use MIN(COLLECT around each Child rows with the criteria, then get the MIN of that as well:

=MIN(MIN(COLLECT(CHILDREN(col1@row), criteriaRange1, criteria1)), MIN(COLLECT(CHILDREN(col2@row), criteriaRange1, criteria1)))

Let me know if that makes sense and works for you!

Cheers,

Genevieve

CeliaC

I realized that CHILDREN() only applies to a single cell - I'll have to use parallel formulas to refer to the childre cells in multiple columns.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.