Customized Workflow Notifications
![Pamb10](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am investigating the use of workflow notifications. In my sheet I have a parent row with a row for the Project Name. Each child row has the Task name. They use the same column.
I am wondering if it is possible to refer to the parent (Project Name) in a notification for a child task in the notification message content.
Thanks.
Pam
Best Answer
-
Hi @Pamb10
It is but you will need to use a hidden helper column, please see example below. As notifications are row based and would be triggered based on activity in the child row, you simply need to bring the parent row project name down to each row.
Formula for copying - =PARENT(Parent@row)
You can then reference the Helper column in your notifications against the child tasks as and when triggered
Hope that helps
Thanks
Paul
Answers
-
Hi @Pamb10
It is but you will need to use a hidden helper column, please see example below. As notifications are row based and would be triggered based on activity in the child row, you simply need to bring the parent row project name down to each row.
Formula for copying - =PARENT(Parent@row)
You can then reference the Helper column in your notifications against the child tasks as and when triggered
Hope that helps
Thanks
Paul
-
Thank you! This is an excellent idea.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives