Reference a CHILD or even GRANDCHILD in an automated email

Jeana ✭✭✭✭✭✭

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.

Best Answer


  • Jeana
    Jeana ✭✭✭✭✭✭

    Had to had helper columns to gather the data but it worked.