Send automated alert when a cell changes from a specific value to a different specific value.
Hi, I'd like to send an alert when a dropdown value changes from one value to another.
For example. I have a dropdown column of
Cat
Dog
Horse
I only want to send an alert when the dropdown changes from Dog to Horse.
I do not want it to send if it changes from Dog to Cat and I do not want it to send if the original value was Cat. Is this possible?
Thanks!
Answers
-
If you set a condition of Animal = Dog (using "Add a condition to filter rows") and then use
When Animal changes to Horse I think that should work ....
(the logic seems backwards, doesn't it? You tell the tool what the trigger is, and then tell it to apply the trigger to certain rows ...)
dm
-
@Emma Tiplady did you ever get a solution to this? I'm looking to do the exact same thing and the suggestion above does not work for me.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives