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

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.<\/p>","bodyRaw":"[{\"insert\":\"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.\\n\"}]","format":"rich","dateInserted":"2022-01-04T21:00:28+00:00","insertUser":{"userID":142714,"name":"Bobert","url":"https:\/\/community.smartsheet.com\/profile\/Bobert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T20:00:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/314823#Comment_314823","embedType":"quote"}"> 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.