Automation based on date


Hi, I'm looking for a formula that can be used to automate sending out a reminder based on a certain date for every X number of years. For example, I have an "invoice due" date column, and then a column next to it saying "number of years." That number of years can be every (1) year, every year for two years, every year for three years, etc.

If I wanted to insert a formula saying send reminder when invoice due column reaches that date, as well as for two years after, how would I go about that, if the number of years column is different for each row? 

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!