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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!