Is there a way to create alerts for non-specific changes?

I'm trying to create an automation that will send an alert when a certain value changes by more than 7. I don't just want an alert for any change, it has to be if the value changes by more than 7.

Because of the nature of this specific value, it isn't really possible to have a helper column, at least not that I can tell. It is calculating the difference between one static date and one fluid date. The fluid date is also a calculation, and it in turn is based on many other calculations. So due to this fluidity, it isn't really possible that I can tell to have a helper column here.

Any idea? Thank you!



  • Harsh2
    Harsh2 ✭✭
    edited 05/10/23

    Hi @Ariana Arden,

    I would suggest that you convert the fluid date to a real Date by using the DATE function.

    You could then do the math on Smartsheet to calculate the difference between the static date and fluid date and save the difference in a separate column.

    Then create an automation workflow which only sends out alerts if the difference between the two dates (i.e static date and fluid date) (saved in the above newly created separate column) is greater than 7

    Hope this helps!

  • Ariana Arden
    Ariana Arden ✭✭✭✭

    Hi! I appreciate your response, but it doesn't actually solve my issue. I don't need to know if the difference between the dates is greater than 7, I need to know if the difference between the dates changes by more than 7. It's a weird problem, but thanks for your advice anyway

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!