Why this formula's returns #INVALID DATA TYPE


I wonder if so can help me understand why this formula does not work.

=COUNTIF([Request Date]:[Request Date], MONTH(@cell) = 10)

Where the Request Date is indeed a Date column.

It is probably pretty obvious but cannot find it.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!