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
-
Can you share your automation workflow setting? Do you have a Condition block like this in your automation?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Can you share your automation workflow setting? Do you have a Condition block like this in your automation?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
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.
-
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
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives