Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Setting a reminder - automation not working

Hello, I am trying to set up a reminder to go out three days prior to the "Start Date" - I've tried using the trigger for rows being changed as well as dates changing, but nothing seems to work. See below sample. What am I doing wrong? Thank you in advance!


Answers

  • ✭✭✭✭✭✭

    Hi @bedholm ,

    Change your trigger to When a Date is reached

    Select Custom and change it to run every day

    You can then set what time of day you want it to run and the other conditions you already have.


    Hope that helps!

  • ✭✭✭
    edited 05/23/23

    Hmm - I am not sure that will work. I am looking to send this reminder only once - the custom field seems to offer this to be a recurring reminder.

    We have new hires starting and want to send a reminder to the Manager 3 days prior (just once).

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions