Reference a CHILD or even GRANDCHILD in an automated email
I want to send an automated ALERT based on the information in this pic. The alert will go to the Task Owner and I would like it to read something like this with the cell references to include the items in all caps. The issues is the PARENT/CHILD relationships I believe. Any suggestions on how to make this work?
Pic of the sheet.
Here's what I'm getting.
In this case 1st Designer Review is the Descriptor for the ROW that I'm trigger the Alert for.