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.
Automatic reminders based on dates
very new to smartsheet so please be kind
I have a requirement whereby I need to badger suppliers to ensure that they will deliver on schedule, so I'm hoping to do the following:
Add a column for expected delivery date
Add a tickbox for "will require chasing"
Have a reminder automatically set to trigger at 50% of delivery date - entry date, so for example if delivery is say 3 months, then to send a reminder that it will need chasing after 6 weeks from the day the order is added to the smart sheet.
The addition of the columns is straight forward, and I can see how to set a manual reminder, but I can't find anything that helps me automate it dependent upon the delivery date. Can anyone point me in the right direction please?