Reminder template/workflow

I need to create the same reminders over and over again based on a date in the spreadsheet.
Scenario: we offer classes, each on its own date. I need to send out various info to students as follows: one week before; one day before; one day after; two weeks after. That sort of thing.
(There is slight variation based on the class name, but that's it. I'd be fine with creating a separate workflow for each one.)
How I'd wish it to work: when the date is added or changed, I have a workflow I can add to that row so I don't have to recreate the set of reminders every time I create or change an entry.
sorry if there is an obvious solution, but I'm brand new. I do have a bit of SQL experience, but that is much more flexible!
Answers
-
Hi @wkhuser
I hope you're well and safe!
Try something like this. (copy and modify for each option)
Make sense?
Would that work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That's perfect! Thank you!
Now if I could just copy workflows between sheets... (womp womp)
-
Excellent!
Happy to help!
Yes, to be able to copy workflows between sheets would be amazing.
✅Remember! 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.