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.

Reminders

Ron Biggers
edited 12/09/19 in Archived 2015 Posts

New to Smartsheet - I see that a reminder can be set to a maximum of 14 days prior without setting a calendar date. My guess is the 14 day prior will float with a change in the schedule (rain days, etc.). Does the calendar date float as well? If not, how can a reminder be set for more than 14 days & still float?

Comments

  • Travis
    Travis Employee

    Hi Ron, when you set a specific date for a reminder, it will not change when a date in your row changes. Heres a workaround for you:

     

    -Add an additional Date column to your sheet (Reminder Date)

    -Add a formula to the Reminder Date column that adds X days to the corresponding Date cell (such as your Start or End Date)

    -Set reminder for the Reminder Date column

     

    Here is the formula you can use to add 30 days to your Start Date:

     

    =[Start Date]1 + 30

  • Thanks.  But how is a reminder set to a column other that the start column?

     

    Ron B.

  • Never mind, I got it.  When yolu set up a Date column, the column is shown in the Reminders window.  Thanks.

  • Seems as though I don't have it after all.  I don't understand the formula and how that would trigger an Alert.  Your help is appreciated.

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    Ron,

     

    Based on your last question of "If not, how can a reminder be set for more than 14 days & still float?", Travis gave you the formula to add 30 days to the Start date.

    That means if the Start Date is 10/1/15, the Reminder DAte is +30 days or 10/31/15.

     

    So then you would then create a Reminder alert for the Reminder Date column to occur "on" the Reminder Date, 10/31/15.  Thus allowing you to set a reminder more than 30 days out.

     

    Hope that helps.

    Tim

     

     

     

     

    Reminder date2.JPG

  • Ron Biggers
    edited 09/22/15

    Thanks.  Would the Reminder Date then float with changes in the schedule or be fixed at that date rather that with the typical reminders of up to 14 days.

  • Travis
    Travis Employee

    Ron, yes the Reminder Date will float when changes are made. The formula I provided will add 30 days to the corresponding Start Date date - no matter what that date is or it if is changed. It might make more sense if you add this to your sheet and play around with changing the Start Date. 

     

    Let us know if you run into any issues setting this up! 

  • Will this work for a sheet with different reminder dates on multiple rows?

This discussion has been closed.