Set automation condition dependent on value in another cell?

MathewL

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"

Paul Newcome

You would need to set up a helper column in the sheet (can be hidden after setup to keep the sheet clean) with a formula to output something when that condition is met. Then you would set up your automation to trigger when this helper column changes to that particular output.