Parent Children IF CONTAINS Function query
Hello all,
I'm trying to resolve a function for my sheet below.
The basis of the sheet is that a user select "Yes" from the Payment Certificate column which results in Yes populating the Parent Row of the Payment Certificate Helper column. The current formula I'm using is based on me selecting/inputting the 2 or 3 rows manually in the Child tasks  I'd prefer to have the Parent Row automatically look at the Child Rows below because the number of rows in the Children will grow over time.
Then with this resolved, I'll copy and past the formula to each Parent Row.
As an alternative, I'd be happy to have a formula sit in the Parent Row of "Payment Certificate" but I'll probably have to change the font colour so users cannot see it.
Thanks for any advice.
Best Answer

Try this...
=IF(CONTAINS("Yes", CHILDREN([Payment Certificate]@row)), "Yes")
Answers

Try this...
=IF(CONTAINS("Yes", CHILDREN([Payment Certificate]@row)), "Yes")

Thanks Paul, I appreciate your help.
I should have worked that out myself.
I think Smartsheet should provide additional examples possibly using combinations of other functions;
https://help.smartsheet.com/function/contains only provides one  a list of samples would help.
Thanks again.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!