Trying to use TODAY function

The first part of the formula below works, its only after I add ", TODAY () > [Bid Due Date]:[Bid Due Date]" that I get an error.

=COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability", TODAY () > [Bid Due Date]:[Bid Due Date])

Any help is appreciated

Find more posts tagged with

Accepted answers

All comments

Eric Law

Hello @Sean Maney

Please edit your formula to

=COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability",[Bid Due Date]:[Bid Due Date], < TODAY ()) and it should work.

Sean Maney

Didn't work...?

Sean Maney

=COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability", [Bid Due Date]:[Bid Due Date], < TODAY (10))

Any other ideas?

Eric Law

Can you screenshot what you see?

Mike TV

@Sean Maney

What error are you getting with the updated formula?

Are either the "R1 - Bid/No Bid" or "Active - High Probability" in multi-select dropdown columns? If so, you'll have to use CONTAINS to confirm if the cell contains those as part of multiple choices selected.

Sean Maney

#unparseable

Sean Maney

they are not drop downs

Mike TV

@Sean Maney

Is the Bid Due Date a date which is generated by a formula? If so, maybe SmartSheet doesn't think it's a date? Try this somewhere:

=IF(ISDATE([Bid Due Date]1), "Is a date", "Not a date")

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.