I have a sheet and want to automate a request to assignees to provide an update at the same time each month.
How can I do this without a due date and a formula driven checkbox or flag that would trigger the request?
You can do this with an recurring update request via automation.
I've posted a quick video on how to set it up here: https://www.loom.com/share/6c775b093b4a4b7283cf1f8548bc70bd
You can see an example in Smartsheet here:
Hi @Phil Wightman
To add to Caseys excellent answer.
Here are some more information.
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Hi @Casey DuBose (Jalubro Consulting) ,
Thanks so much for the response and the video that made it super easy to understand what to do.
This wont work as it is triggered when a 'date is reached' in your set up.
Having the date column was not part of my plan as in theory I would need to have a date column for every month and a separate workflow for each month? Unless I am missing something.
My sheet is simply a monthly update report on rows where row assignees neeed to update it durig the third week of each month. So the trigger if any is the third Monday and they have until the follwing Friday to provide the update.
If you have insight as to how I can achieve this it woudl be great. Thanks for sharing again.
Hi @Casey DuBose (Jalubro Consulting)
I looked over your response again and apologies as the custom set up is the solution I was looking for. Thanks again.