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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!