How do I make some columns on a children's row update to match the parent as parent cell changes?

Hello,
I have a spreadsheet I was given that has styles listed out as Lots which are product specific and then below are children rows that are listed out as SKUs which are product/color specific. In order to not have to alter the same information on each SKU row, how do I make the SKUs row alter it's information based on what is changed in the parent row. Example: if my parent row is marked in process - all the children rows automatically move to in process as well.
Answers
-
@Rhea You could leverage the Ancestors() function: https://help.smartsheet.com/function/ancestors
Now, you'll need to wrap the ancestors() function in a JOIN() in order to get the value to be displayed as text.
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite