Return value in Parent Cell for Child value

Options
rstrecker
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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!