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.
Notification Sent to Assigned Contact 4 Weeks Out...
We run about 200 events per year and need to inform our trainers that they're assigned 4 weeks before the event start date. I know I can use the Reminder feature to send a reminder up to 2 weeks out, but that's not enough lead time.
The master sheet we use is initially populated as an "Event Request" using a webform. So my idea of inserting an equation into a column (event start date - 28 days) won't occur automatically, because the info is all populated via webform.
Long-winded way of saying: I'm looking for an automated way of alerting folks 4 weeks out if they've been assigned to an event. Any ideas?