Automated Workflow Question

Laura_Thomas

I have a sheet where each row holds the details of an event. Each event has a start date, and I've set up automated workflows to send event attendees reminder messages. One flow is set up to send an "initial" reminder message 21 days out from the start date. The other flow is set up to send a "final" reminder message 14 days out from the start date. 

However, attendees are getting both reminders at once. For example, one attendee has an event scheduled to start on 8/17, and she got the 14 day and 21 day out reminders today. I've looked over the automations very carefully and think they are set up correctly but is there something I'm not understanding about workflows to cause this? 

Paul Newcome

I would suggest inserting some helper date columns and using a basic formula to output the desired date. From there you can set your automations to run on that specific date column.

=[Start Date]@row - 14

=[Start Date]@row - 21

Andrée Starå

Hi @Laura_Thomas

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Laura_Thomas

@Andrée Starå absolutely

2 Week Reminder.png

3 Week Reminder.png

Sheet Headers.png

Paul Newcome

I would suggest inserting some helper date columns and using a basic formula to output the desired date. From there you can set your automations to run on that specific date column.

=[Start Date]@row - 14

=[Start Date]@row - 21

Laura_Thomas

@Paul Newcome thank you, that seems to have handled it!

Paul Newcome

Happy to help. 👍️