Return value in Parent Cell for Child value

rstrecker ✭✭
edited 12/09/19 in Formulas and Functions

I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status.

For example, I want the STATUS column of the Parent row to populate with the STATUS of the Child where the Child DOCUMENT TYPE = "Trust Agreement".  I've tried a few different formulas, but none of them are picking up the correct Child Status for the Trust Agreement value.  

Any help with the formula would be greatly appreciated.

Smartsheet Index Match help.jpg



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!