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


  • alcapps
    alcapps ✭✭✭

    Yes, that makes sense. i didn't think it could be done but wanted to be sure. This sure would be a nice enhancement :)

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Feel free to Submit a Product Enhancement Request when you are able.

    Additionally... If you would like more detail or help setting up the Update Request version, let me know.

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!