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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!