Why this formula's returns #INVALID DATA TYPE

Options

Hello,

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.

Raoul.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!