Need an automation of 'One week before' instead of 'When a date is reached'. Is possible?
Hi, I'm trying to do an automation of alerting a person in the team when the actual date is one week prior to a 'start date' column. I thought this would be super-easy, but frustratingly, smartsheets automation option only allow 'when a date is reached'. I'm surprised they don't run more options eg '7 days before a date is reached'..etc.
Maybe I'm missing something, or is there a work around that can be done at cell level to get an automated alert the week before a start date.
Many thanks
Answers
-
Sounds like you were close!
Create a new automation
- trigger: when date is reached
- run once, then change the "on" option to "1 week before"
- then select your date column
-
@Steven Evans is there any way to note for the trigger to run on a date not in a week range? That is, you chose "1 week before" but is there a way to tell it to run "X days before" where X = 1 to n? Or are we tied to the specifics in the workflow?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!