Send automated alert when a cell changes from a specific value to a different specific value.
Hi team,
I was attempting to build out a process for an automated alert to be sent based on a value in a cell (drop-down list(constant)) changing to a different value (also from the dropdown list) of that same cell. I would like want the alert sent if it was being changed from that specific value to another specific value.
For example, Drop down list is Red, Blue, or Green. If the value is set to Red then changed to Blue, I want the alert sent. However, if the value is Green and then set to Blue, I don't want the alert sent. I ONLY want to know if the value goes from Red to Blue.
I have only found a way to set the alert to be when that cell changed to the end value(Blue) using the alert functionality in Smartsheet. This would include any previous values (Red or Green). That is not what I want to have happen.
Any ideas? Thank you!
Comments
-
You would have to have the previous color manually inputted into another column to compare against.
-
Hi,
How often does the value change?
Depending on the specifics, the third-party service Zapier could be an excellent option for this scenario. Is that an option for you?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I am looking for a solution to this EXACT question but I don't see a clear solution here. Did you ever find a solution?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives