Parent Children IF CONTAINS Function query

Richard Heath

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.

Paul Newcome

Try this...

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

Paul Newcome

Try this...

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

Richard Heath

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.