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.
Best Answer
-
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.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
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.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Had to had helper columns to gather the data but it worked.
Thanks
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives