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

Rhea

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.

Darren Mullen

@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.