Set automation condition dependent on value in another cell?


I am trying to setup some automation to generate a reminder when the value in one cell (a date) is less than the value of another cell (also a date). I can't use a fixed date as the dates in each cell are different.

This is an example of a basic automation script with the condition logic/wording I am wanting shown in italics. Does this functionality exist anywhere or is there an alternative?


When a date is reached, run once: "30 days after"

Date field: "Application generated"


Where "last application date" "is less than" "Application generated"

Alert Someone

Send to specific people "etc etc"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!