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.

SoS | Dan Palenchar

I believe the #2 you've placed after {{Previous Step}} is throwing this off. The fields reference the row in question, so if you want to provide data about a previous row add a column that pulls in the previous row data and reference that in the automation message.

SoS | Dan Palenchar

I believe the #2 you've placed after {{Previous Step}} is throwing this off. The fields reference the row in question, so if you want to provide data about a previous row add a column that pulls in the previous row data and reference that in the automation message.

Jeana

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

Thanks