Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
New Row notifications via Send option
Comments
-
Skip,
Zapier (www.zapier.com) will do this.
The row comes in vertically, so that is also nice.
Depending on how many sheets you want to have this functionality and how many new rows you have will determine if Zapier is cost effective.
Here's a post I wrote last month about determining if it is or not:
https://www.linkedin.com/pulse/automate-question-craig-williams-pmp-
The Zap took 8 minutes to set up and test and looks promising.
Ideally, we wouldn't need to go outside Smartsheet for this functionality, but I don't like my in-Smartsheet work-around for this (and I'd have to retest for this use case).
I believe rolling up the rows into a single email should be the default behavior.
Perhaps the Conditional Notification feature(s) on the roadmap will affect this.
I hope this helps
Craig
-
Add a "send immediately" in the Alerts/notifications...Just make sure you have have a column that will always be "new" whenever a new row is created. For example, a name of a task or something.
-
Jeff K.
I believe I have seen mixed results when adding rows directly (I often do them in blocks) using this method, but it has been a while since I tested that functionality.
Skip,
If you are adding rows via a WebForm, add a new check box column (I use [WebForm Submitted] and have it default checked and hidden. Key the notificaton off that.
Craig
-
I am adding rows from a form on our website. When a row is added I send an email to user(s), using the the date created column since that always changes from blank to a date, and it works fine. The users have their similar emails grouped, so the notifications are being added to the one email. If there is a way to make each one unique (Subject line has Firstname lastname) then the notication alert would work.
-
@J. Craig Williams...Yea, in my experience, the "Immediately send email" Notifications only applies when you hit save... So if someone fills in a couple of rows and hit send, then SS will send the email as a block, rather than individual emails/row.
-
Jeff,
Ah, that seems so obvious now that you have typed it
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives