HAS and Children Functions

Mike Dufour

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?

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!

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!