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 multilevel 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?
Best Answers

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

Thank you Carson, very helpful!
Answers

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

Thank you Carson, very helpful!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.4K Get Help
 61 Global Discussions
 46 Industry Talk
 384 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!