Automation from Cell Value


I'm trying to create an Automation that sends an email when a cell in column is above a certain value. I would preferably like to reference the value of another cell in the same row in the email. I only seem to be able to create the Automation when the cell is exactly a certain value not above a certain value.

As an example, I want to send an email when the Quantity is above 40. I want the email to reference the Unit in that row. So, I want to send an email that references Apt. 107. I would really appreciate your help.


Best Answer