can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)

dwallace

Im looking to set up a reminder automation that will send out reminders on a weekly basis if tasks are not completed by a certain date. In my sheet there are numerous dates and they are pulled in from formula (dynamic) meaning that i need to pull it off a specific column / cell in the sheet. although the automations allow you to set them up to run daily/weekly/monthly from a certain day of the week and specific date, i cant see an option to set it up weekly from a certain date cell. does anyone have a solution around that? possibly using alternative sheets or something?

Thanks in advance!

Paul Newcome

Yes. This formula will essentially output a date that is 7 days past [Start Date]@row and will increment every 7 days.

So basically it will output the date 1 week from the original date. Once that first week has passed, it will output a date 2 weeks from the original date. Once two weeks has passed, it will output the date 3 weeks from the original date, so on and so forth.

You have two options to only have it running when something is not complete, you can either wrap it in an IF statement

=IF(Status@row <> "Complete", date_output_formula)

Or you can include it as a condition within your reminder automation.

Paul Newcome

Try this in a helper (date type) column then set your automation to run on this column.

=[Start Date]@row + CEILING(TODAY() - [Start Date]@row, 7)

dwallace

Hi Paul,

Thank you for your speedy reply, will this send out automations on a weekly basis if chosen?

Paul Newcome

Yes. This formula will essentially output a date that is 7 days past [Start Date]@row and will increment every 7 days.

So basically it will output the date 1 week from the original date. Once that first week has passed, it will output a date 2 weeks from the original date. Once two weeks has passed, it will output the date 3 weeks from the original date, so on and so forth.

You have two options to only have it running when something is not complete, you can either wrap it in an IF statement

=IF(Status@row <> "Complete", date_output_formula)

Or you can include it as a condition within your reminder automation.

dwallace

Amazing Paul thank you so much!

Paul Newcome

Happy to help. 👍️