Return value in Parent Cell for Child value
Options

rstrecker
ββ
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.
Tags:
Comments
-
Try adjusting your ranges.
Β
=INDEX(CHILDREN(), MATCH("Trust Agreement", CHILDREN([DOCUMENT TYPE]@row), 0))
-
Thanks so much, works perfectly!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!