TODAY Function randomly stopped working in my Summary Metric formulas, how do I fix?


In a SUMIFS function I am using a date check to sum all cells that have an expiry date equal or greater than TODAY: =SUMIFS(Expiry:Expiry, >=TODAY())

This worked for over a year but suddenly is giving an error message, any idea if something in the TODAY function changed?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!