Return value in Parent Cell for Child value

10/30/19 Edited 12/09/19

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


Sign In or Register to comment.