Automation Using Dates to Generate Reminders

Hi Everyone, New to Smartsheet so sorry for the rudimentary question. I'm having trouble getting automation to do what I want it to. I have a project sheet with multiple tasks with various due dates. I'm trying to send reminders prior to the due date. I do the following:

Trigger: Run Once: On: Date Field: Due Date: 9:00AM

Condition(1): Where: Due Date is today

Condition(2): AND Where Complete is not checked.

Alert Someone.

The sheet sends reminders out for all tasks rather than just the one I intend. What am I doing wrong?

Scott

Find more posts tagged with

Sheets

Comments

Andrée Starå

Hi Scott,

There was an issue earlier today.

More info: https://status.smartsheet.com/incidents/0m04hmrhwr25

Is it working now?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Scott Willeke

Hey Scott,

I tried this out and it seems to be working for me. I placed a screenshot of my workflow configuration and how I set this up in case it might be helpful for you to see how I've set up the recurrence pattern and conditions.

If you continue to have problems though, let us know! We definitely want to get to the bottom of this and make it work for you.

--

Scott Willeke | Smartsheet

Director of Product Management, Automation

Screen Shot 2019-06-21 at 4.01.59 PM.png

Chak Khiam

I have noticed that in your Trigger, you have selected "Run Once".

Click on the dropdown next to "Run Once", then turn the Trigger to "Custom".

A dialog box will open. Choose "Day" and keep the "1" if you want to be reminded/notified Every Day with a starting date, as shown in the automation rule provided by Scott W.

Sign in to join the conversation!

Quick Links

Trending discussions

Grid creation
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
Share Tab not activated
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?