HAS and Children Functions

I have the following column1 formula:

=IF(HAS(CHILDREN([Column2]@row), "Text"), 1, 0)

which sets the value of column1 to 1 if "Text" is found in any children in Column2

This formula works well for a single nested file of children.

However, I have a multi-level nested file (i.e. Parent1, Child1, Parent2, Child2) and it appears the formula looks at 1 level of nesting only, as Parent2 has the correct value, but not Parent1.

My expectation was that the CHILDREN function looks at all levels below the Parent. Am I correct that the CHILDREN function looks at 1 level of nesting only, and if so, is there a method to assess all children, regardless of the levels of nesting?

Find more posts tagged with

Accepted answers

Carson Penticuff

CHILDREN will only look at entries one level down. DESCENDANTS will look at all levels below current.

Mike Dufour

Thank you Carson, very helpful!

All comments

Carson Penticuff

CHILDREN will only look at entries one level down. DESCENDANTS will look at all levels below current.

Mike Dufour

Thank you Carson, very helpful!

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.