Set automation condition dependent on value in another cell?

Options

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?


Trigger

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

Date field: "Application generated"


Conditions

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


Alert Someone

Send to specific people "etc etc"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!