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.

Find more posts tagged with

Accepted answers

Paul Newcome

Try using a SUMIFS instead...

=SUMIFS({Other Sheet SUM RANGE}, {Other Sheet PRODUCT NUMBER COLUMN}, "01-05204", {Other Sheet DATE COLUMN}, >=TODAY(-90), {Other Sheet DATE COLUMN}, <TODAY())

Paul Newcome

help.smartsheet.com

It has a learning center, training options, and other various resources. Definitely a great place to start. I personally have also gained a lot of knowledge through this community as well.

All comments

Paul Newcome

What is it doing vs what should it be doing?

Robert Stuffings

Hello. So I found that my original script I listed isn't going to do what I want it to do.

I am trying to have a sheet look at another database sheet and every time it comes across a part number it will add up the total in the inventory cell. and to look back 90 days.

Is this script that SmartSheets is using similar to anything else so I can look at a course or learn more about what I am trying to do?

Paul Newcome

Try using a SUMIFS instead...

=SUMIFS({Other Sheet SUM RANGE}, {Other Sheet PRODUCT NUMBER COLUMN}, "01-05204", {Other Sheet DATE COLUMN}, >=TODAY(-90), {Other Sheet DATE COLUMN}, <TODAY())

Robert Stuffings

Thanks. I will give that a try.

Robert Stuffings

It works. Thank you so much for the help.

Is there a resource for learning more about scripting?

Paul Newcome

help.smartsheet.com

It has a learning center, training options, and other various resources. Definitely a great place to start. I personally have also gained a lot of knowledge through this community as well.

Andrée Starå

@Robert Stuffings

Here's another excellent resource.

https://excellence.smartsheet.com/

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.