Is it possible to trigger an alert notification ONLY if the value of a field increases?
I have a formula that counts absences for the past 6 months. A formula in another column looks at the first and when that number reaches 3, it adds an occurrence (value changes from 0 to 1). I've set up automation to notify the supervisor that the team member needs a counseling.
Since my only option for automated notifications is to trigger when that field changes, when the absences drop off (older than 6 months) the occurrence field drops by one which triggers an alert notification. I do not want this one to trigger a notification.
Help Article Resources
Check out the Formula Handbook template!