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

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @Emma Tiplady

    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