How to deliver notifications by individual row after multiple row update
Hello Community!
I would like to to have smartsheet deliver a single email notification or Microsoft Teams alert after a user updates multiple lines. Right now, I can update multiple lines on the sheet but only one email or notification is sent with the changes grouped together.
I want the individual lines that were updated sent as separate emails or notifications. The individual line alert also allows the use of the {{Column Name}} feature to be utilized in alerting the recipient of the exact task name that requires attention. When the large update email comes through the {{ }} does not function.
Single Alert Example:
Grouped alert example:
I believe the individual alerts can be accomplished by saving the sheet after each line is entered or changed, but the alert email sometimes still groups changes together.
I tired adding a check box that says 'alert the ATTN To' Contact and ran the alert run off that condition instead of an assigned to, but notifications still grouped together.
Thanks!
Matt
Answers
-
Hi Matt
If multiple rows are changed when the sheet is saved within the timeframe of the selected frequency, then the workflow will run for every row that meets the trigger criteria. The recipients of this automation will receive a single notification with up to 100 rows in a grid format.
The behavior you described (when using placeholders) doesn't seem to be expected. Based on this Help Center article, using the placeholders should result in separate alerts for each row. Please feel free to reach out to our Support team to troubleshoot this further.
-
Hi Alejandra,
Thank you for the reply.
I am wondering if the placeholder solution is not working because the ATTN to is the same contact, and the alert is grouping per ATTN to?
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