Alerts and Actions not working

Hi,

I have a sheet where the RYGG is automated based on the due date (overdue=red, due date +2=yellow, the rest=green). I then set up the alerts ("Send a notification") so when the status turns yellow one email goes out, and when it turns red, another one gets sent out. I've played around with this for a few days. I have the test emails set to my email address, but no emails. It only seems to work if I go in and change the status myself, which defeats the purpose. Would really appreciate any help on this.

Thank you,

Find more posts tagged with

Formulas

Update Requests

Email Notifications

Comments

Tim

Having read your comment i thought i would see if the same happened for me. I can confirm that I did receive a notification based on a change in the variables when driven by a formula.

Heba H.

Any tips? I know your original comment said it didn't work, but it looks like it is working for you now.

Tim

Is your Alert a notification, if so how long to notify, or an update request? I have both set up in trial mode and the update request is set to "right away" and that is the one I have received emails from.

Heba H.

Yes, it's a notification and set at right away.

Tim

Just set that up for myself and received the notification in minutes.

Are you expecting your notification to be triggered even if you do not go into the sheet or do not make changes to the sheet, e.g. if time elapses and a variable changes?

Heba H.

Ideally, I would like it, once it changes colors as the date changes, for an email to be sent out. However, I know the sheet needs to be active and that it needs to be open, and even refreshed the next day. But even after that, no emails were sent

Sarah_lee123

I am having issues getting the emails to trigger as well. Mine is not complex and is set to trigger when a box is checked in the sheet. When I go in and check the box, nothing happens. I have three separate rules for three different boxes. There are no conditions and it is the simplest alert that can be created. I am confused as to why the alert is not being triggered.

Any Ideas? It's seems like the above comments are just talking about how it is working for them, but not much on troubleshooting the issue. Thoughts?

See attached screenshot

Smartsheets alert issue.png

Shaine Greenwood

Hi Heba—

Formulas will only run and reflect the updated status once your sheet is opened and saved.

You'll need to open and save your sheet for the status to update and then trigger the automation workflows that you've made.

If you're already doing that, you may need to adjust your account- or sheet-level alerts and actions settings. More information on this is available in the help center: https://help.smartsheet.com/articles/2476586-control-who-is-notified-about-alerts-and-requests

Gil Nash

Was there ever a resolution to this thread @Heba H. or @Sarah_lee123? I'm having the same issue the past few weeks when testing some new automations. The other contacts I have set to receive the email are working properly, it's only my work email that doesn't receive them. My work email is in the Sub. By Other cell below on the sheet. My personal email is listed under the specific people along with a coworkers work email address.

I still get all other previous updates to sheets and other automations that I have set up.

Is it possible that I'm not getting the test notifications to my work email address because I'm logged into Smartsheet under that same email address making the sheet changes that trigger the automation?

Andrée Starå

Hi Gil, @Gil Nash

First, make sure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the upper right corner) and secondly check the Permission.setting for the Automations. (cog in the upper right corner in the Automation overview)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?