Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
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 - 30You 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
