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?
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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!