Formatting based on child row
Is there a way to update the parent row based on the child row?
Every time a new product goes out for testing, it is added to my sheet as a parent row. If that product needs to be retested, I am adding it as a child. If the child passes testing, is there a way to update the results in the parent row?
Help Article Resources
Check out the Formula Handbook template!