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
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!