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

Anne77 ✭✭
edited 11/22/22 in Formulas and Functions

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!