Reference a CHILD or even GRANDCHILD in an automated email

Jeana
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?


Screen Shot 2020-08-14 at 10.03.37 PM.png

Pic of the sheet.

Screen Shot 2020-08-14 at 10.06.18 PM.png

Here's what I'm getting.

Screen Shot 2020-08-14 at 10.07.56 PM.png

In this case 1st Designer Review is the Descriptor for the ROW that I'm trigger the Alert for.

Best Answer

Answers

  • Jeana
    Jeana ✭✭✭✭✭✭

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

    Thanks