Reference a CHILD or even GRANDCHILD in an automated email

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


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

Answers

  • Jeana
    Jeana ✭✭✭✭✭✭
    Options

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

    Thanks