How can I capture the value in a parent row to match the value in one child row?

Anne77

I have a matrix by job title that each child row enters one value. So there are 4 child rows, but only one value in each of the 4 columns. I want the parent row to reflect the value when not blank of the child row beneath it. Is that used with a MATCH formula? How can it reflect "if not blank" and take that value, whatever it is? Names may be reassigned so I want the parent to change along with it.

Mike TV

@Anne77

You can simply put =JOIN(CHILDREN()) into the Manager cell of the parent row and drag it across to the last column. It will end up like this:

Mike TV

@Anne77

You can simply put =JOIN(CHILDREN()) into the Manager cell of the parent row and drag it across to the last column. It will end up like this:

Anne77

Thank you!!