Problems using @cell with dates when range contains blank cells
Options
Hi,
I've been trying to use this formula:
COUNTIF(Due Date, MONTH(@cell) = 8, but it returns an error INVALID DATA TYPE
If I limit the data range to exclude the blank rows than it has no problems. But this is not pratical because later when I more tasks, I have to adjust the formula. Interestingly SUMIF does not have this problem using similar parameters.
Besides creating a new column to calculate the month separately any other solutions?
Tags:
Comments

Try this instead:
=COUNTIF([Due Date]:[Due Date], IFERROR(MONTH(@cell), "") = 8)
This should let you skip the blank cells.

Nic, thanks that works!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!