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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!