I cant get the TODAY function to work in this script.


=COUNTIFS({Quality Inspection System (Failures) Range 2}, "01-05204", {Date}, >=TODAY(-90), {Date}, <TODAY())

I am new to writing scripts and am kind of stumbling about. I have used the TODAY function once on another sheet and it worked. I have tried the Smartsheet formulas examples page without any luck.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!