Hello, I got 3 differents needs which are pretty much the same :
- I need to send a notification when a date is pushed back for more than a week (under than a week, that’s junk mail)
- I got the same need where I filled a week# in a number column instead of being a date.
- I got the same need for a status : if the previous status was this, then do this
I could also live with sending notifications everytime as long as I’m able to tell what’s the difference between the initial and the new value.
So basically, I would like to record the initial value in a column when the column changes (each time it’s changing), have a formula column that calculate the difference between both column (which shoud be pretty easy), and, when the column changes again, sent a notification.
I’ve tried something similar with a status, which is more simple, but I have a problem where the trigger is the same thing : “When column changes” and it’s doing both automation at the same time.