How to stop Alerts being triggered by TODAY() formula

Peter D
Peter D
edited 12/09/19 in Formulas and Functions

Hi Everyone,

This is my first post on here and hope someone can point me in the right direction.

I have a formula cell which references TODAY() in a certain IF criteria. I also have several alerts going to various users which are generated if cells are added or changed on specific rows (including an alert to myself to show any changes made to the sheet the previous day). 

Once a user has "touched" the sheet it will automatically update the TODAY() formula cells generating an alert as per the rules set.

Is there a way to stop alert triggers from looking at that one field without having to add criteria for all other fields on the sheet (which I can't do as I have too many other fields) or a way to prevent alerts from referencing cells with a formula?

Any help would be greatly appreciated.


SmartSheet - Screengrab.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!