Automation from Cell Value

Bobert

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.

Jeff Reisman

Can you share your automation workflow setting? Do you have a Condition block like this in your automation?

Jeff Reisman

Can you share your automation workflow setting? Do you have a Condition block like this in your automation?

Bobert

Thank you. I do have that and I was able to create the Automation. I was changing the trigger to the field I was worried about and that was only allowing me to select a specific value. Basically, i was trying to stuff both the Trigger and Condition into just the Trigger field. Thanks. I really appreciate your help.

Jeff Reisman

https://community.smartsheet.com/discussion/comment/314823#Comment_314823

That's exactly what I suspected! I may or may not have done that same thing a few times 😃. Glad I could help.