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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives