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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!