Conditional reminder

Does this send an alert ONLY 30 days out, 20 days out and 7 days out - or every day that is less than 30, less than 20 and less than 7?


I want to send a reminder to complete a task ONLY 30 days before the end date, 20 days before the end date and 7 days before the end date conditioned on the task being a milestone/not done.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!