How to send automated daily digest email of updates

kss5229

I'm trying to set up an automation to send a daily digest email of updates to users linked to an item in Smartsheet.

I have a smartsheet where each row is an event. When any cell in that row changes, I want the users involved to have some notification of the change. My current automation is triggered "when rows are changed" and accommodates for a change made to any cell for every column. When I tried to set the workflow to run "daily" instead of "when triggered," I get a "workflow timing is unavailable". Setting up the workflow to run when triggered results in an excessive number of emails sent to the users involved.

kowal

Hello,

This is how Smartsheet works only for request for update or other workflows you can send it hourly, daily, weekly if it goes for reminders it needs to be sent when triggered.

If you want to send email only once per day maybe you can go this way: add the system column modified date (it captures the last date when row was modified) set it as a condition for sending daily remainders just like that:

Maybe setup the sending time to something like 5PM etc. so it will be only sending the rows that were modified the same day before 5PM.

let me know if it helps.

kss5229

That's a start, but in that "digest" email, it won't highlight the changes that were made will it? I have so many events and so many columns that I am not sure how useful the digest email will be unless it shows the recipient exactly what changed.