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.
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.
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.
Regards,
Jeff Reisman,IT Business Analyst & Project Coordinator,Mitsubishi Electric Trane US
Add a \"Created By\" column in your sheet and turn on \"Required smartsheet login to access your form\" in your form setting. So that whoever fills out the form, their email id will be automatically captured in \"created by\" column. This will replace your \"Requestor Name\" column. <\/p>