Alert and update based on start date, end date and completion %

Hello, I would like to set up the following for a project plan. Reminder to the person assigned in contact column on the day that the task starts (start date). Update Request sent to the same person on the (end date) only if the task is not completed. Can that be done in one work flow, or is that two separate?

Find more posts tagged with

Comments

Randy Van Winkle

Did I not pose this question effectively? No responses?

Andrée Starå

Hi Randy,

We'd use a recurring When a date is reached Trigger and then we'd use two condition paths. One for the Start and one for the End. In the End one, we would also add a Condition to check if the task isn't completed.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Genevieve P.

Hello Randy,

I was having trouble setting this up in the same workflow, as it sounds like your "Trigger" or the reason for each workflow to be sent is different (one is based on a start date column and one is based on an end date column). I would personally set up two separate workflows:

One workflow would be to send an alert with the trigger being "When a date is reached" specifying that the "Date field" is the Start Date column.

The second workflow would be triggered "When a date is reached" but have the "Date field" be the End Date column, and then as Andree suggested, have a condition that it only runs if the task is not marked "Complete."

You can learn more about creating reminders and update requests via our Help Center:

Thanks!

Genevieve

Randy Van Winkle

I think I have it set with two workflows as described by Genevieve. Thanks!

Andrée Starå

Hi Genevieve,

My thought was to use the recurrence to have it trigger daily/weekly or what's needed, and then it should work.

Best,

Andrée

Andrée Starå

Excellent!

Glad you got it working!

Genevieve P.

Hi Andrée,

My apologies, I understand what you mean now. Yes, that would also work, and would keep both notifications within the same workflow.

Thank you for the clarification!

Genevieve

Andrée Starå

No worries and no need for an apology!

Happy to help!

Have a fantastic day!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Column with a restricted list very difficult to edit
Hello, I have a column with a restricted list of 100 entries. When I edit the list and scroll to the 50th entry, as soon as I type to change the entry name the column scrolls to the top and I cannot see what I am typing or deleting. I have to keep scrolling back down to the row to see what I have keyed in. Very annoying…
Change the owner of each item in Smartsheet
Hello everyone, I hope you’re doing well. Could you please share how to change the owner of each item in Smartsheet? Any detailed guidance or best practices would be greatly appreciated. Thank you