Alert recurrence that looks at a date field - possible?

Melisa Dannhauser
Melisa Dannhauser ✭✭✭
edited 03/21/24 in Formulas and Functions

I'm trying to set a recurring alert workflow to remind someone that they need to approve a submission. I have a "submission date" field and I would like a workflow that sends a reminder one week after submission date is reached and then weekly after that, as long as the status field is not changed to "approved".

I was able to set an alert to occur only ONCE, one week after the "submission date" field is reached.

I was also able to set a recurring WEEKLY alert, but I don't see an option to set the start date as the date located in the "submission date" field. The only recurring option I see is to send the reminder weekly, starting on a set date I have to enter from a calendar, which is not feasible as all of my rows will have different submission dates.

Any input on how to achieve this would be appreciated. I really don't want to set 20+ different workflows for each week...



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!