Automation - Alert contact column question
Hi everyone,
This might be pretty basic stuff, but I can't seem to figure it out.
I have a project tracker sheet with parent rows containing information of a project, and child rows with checklist items for that project.
I want to have the sheet alert stakeholders (3 different contact columns) whenever an item list has been checked off. The problem I'm running into is that the automation for this can only be set to "when triggered", not hourly or daily.
My question is, is there a workaround for this? The checklist is quite long and I do not want 6 separate e-mails sent in the span a minute. I ideally want one e-mail either hourly or daily that shows all of the updates at once.
Any help is appreciated. Thanks!
Best Answer
-
Try taking out the {{Placeholders}} in the subject and body. Since the placeholders are specific to whichever row generated the alert, they cannot send an alert that combines multiple rows into one.
Answers
-
Try taking out the {{Placeholders}} in the subject and body. Since the placeholders are specific to whichever row generated the alert, they cannot send an alert that combines multiple rows into one.
-
@Paul Newcome Figured it was something simple and makes perfect sense. Thanks as always Paul!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives