Change frequency of an automated workflow, when a certain date field is reached

Enes

Hello everyone,

I would like to change the frequency of a workflow, when a certain date is reached in one of the date fields. If you currently want to adjust the frequency, then you can only select a self-chosen date as start of the workflow, but not one of the date fields in the sheet. Is there an alternative solution how to work around this problem?

Thank you in advance!

Ryan Sides

Hi @Enes could you use a date field on your row that updates periodically? That way, you could drive the automation from that date instead of replying on the automation's date.

Enes

Hey @Ryan Sides,

unfortunately this is not possible, because the used sheet is a project plan, where the different tasks have fixed end dates.

Ryan Sides

Can you elaborate on the problem you wish to solve without including Smartsheet terms? Like… I want to send an alert every…

Andrée Starå

Hi @Enes

I hope you're well and safe!

I'd recommend adding a Conditional Step or another separate Workflow for the other frequency.

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!