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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!