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.


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!