Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
Comments
-
Hi Colleen—you're right, 14 days is the current limit on Reminders. I've passed your feedback along to our Product team for a larger range (30 days).
With that being said, there is a workaround you might try:
1. Create a new date column in your sheet and title it "Reminder Date" or something to the like.
2. Place a formula in that new column that subtracts 30 days from your original date column: =[Due Date]1 - 30
You should see a date returned that is 30 days before your original date column.3. Create a Reminder based on your new date column.
Voila!
You can even hide the Reminder Date column by right-clicking the column header and selecting Hide Column.
-
Oh, that's a great idea. Thanks!
-
+1 for adding custom option
