Why does my alert keep pulling in the parent row?
I have set up an alert to notify me when a row changes, but instead of it just sending me the rows that were changed, it's also including the parent row (ROW 113 in example), where no changes were made.
The 'Objective' column that I'm bringing in uses the =PARENT(OKR@row) formula so that I know which objective the milestone update is referring to, however, this shouldn't impact on whether or not row 113 is reported, correct?
As noted in the screenshot, the alert says 3 rows changed (in yellow) (rows 122-124), but still includes a 4th row, row 113 where no data was changed.
How can I eliminate the parent row from being included in the alert email? Thanks.
Best Answer
-
Hey @Shane Sorensen,
I can confirm that this is expected behavior. If a Row is changed and it is a Child Row of a Parent, when an Alert is triggered by it, this will include the corresponding Parent Row within the Automated Email.
We don't currently have the ability to omit the Parent Row from the Automated Email sent out via Alert, but you may submit an Enhancement Request via this form for our Product Team to consider for development. We appreciate your input!
We typically communicate about new or improved features once they've been released. Depending on the nature of the changes, we announce through email, in-product messaging, or via announcements here at the Smartsheet Community.
I hope this helps!
Jaykel
Answers
-
Hey @Shane Sorensen,
I can confirm that this is expected behavior. If a Row is changed and it is a Child Row of a Parent, when an Alert is triggered by it, this will include the corresponding Parent Row within the Automated Email.
We don't currently have the ability to omit the Parent Row from the Automated Email sent out via Alert, but you may submit an Enhancement Request via this form for our Product Team to consider for development. We appreciate your input!
We typically communicate about new or improved features once they've been released. Depending on the nature of the changes, we announce through email, in-product messaging, or via announcements here at the Smartsheet Community.
I hope this helps!
Jaykel
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives