Incomplate Online Formula Example - MONTH

Hi Support,

MONTH Function | Smartsheet Learning Center

Unsure where to post this, but the example is missing an end bracket. See below.

=COUNTIF([Sold Date]:[Sold Date], (MONTH(@cell) = 2)

When the MONTH function contains a blank cell within the range of dates it is reviewing, it will produce the #INVALID DATA TYPE error. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR function.

#INVALID DATA TYPE

I know it auto appends, but the examples should be updated. Who verifies the validity of the online formula handbook?

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

@SomeRando You are correct that the formula has a typo. It either needs an additional end parentheses after =2), or the opening parentheses before MONTH should be removed. Either of these is valid.

=COUNTIF([Sold Date]:[Sold Date], (MONTH(@cell) = 2))

=COUNTIF([Sold Date]:[Sold Date], MONTH(@cell) = 2)

Really, the ideal is something like this:

=COUNTIFS([Sold Date]:[Sold Date], ISDATE(@cell), [Sold Date]:[Sold Date], MONTH(@cell) = 2)

When I noticed a lot of problems with the HAS function page, I rewrote a good portion of it and submitted a ticket to Smartsheet Support. It took about 3 months, but eventually my proposed changes were made to the page.

Ipshita

Hi @SomeRando you can submit your idea/feedback here -

https://community.smartsheet.com/categories/smartsheet-product-feedback-%26-ideas

Cheers!

Ipshita

Genevieve P.

Hi @SomeRando (and @Jeff Reisman and @Ipshita)

Thanks for pointing out this typo! I'll make sure the Help Content team receives this feedback.

For future reference, the Support team does not update these pages, nor does the Product team (@Ipshita's link). You can leave direct feedback on articles in the Help Center itself, on the "Was this article helpful" section:

Or, of course, feel free to post here in the Community and I can submit that feedback on your behalf. 🙂

Cheers!

Genevieve

Jeff Reisman

@Genevieve P. Thanks! Good to know!

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.