Getting #Invalid Operation error


Hey all,

Trying to find the total amount of items passing inspection, in a month's time (and also by week). My formulas are below. I keep getting an invalid operation error and not sure why.

=SUMIF(Date:Date, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), [Quantity Pass]:[Quantity Pass])

=SUMIF(Date:Date, >=(TODAY() - 7), [Quantity Pass]:[Quantity Pass])

Any help would be appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!