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

Randy Van Winkle

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?     

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:

• Alerts and Reminders
• Update Requests

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