can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)
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!
Best Answer
-
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.
Answers
-
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)
-
Hi Paul,
Thank you for your speedy reply, will this send out automations on a weekly basis if chosen?
-
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.
-
Amazing Paul thank you so much!
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives