SUMIFS referencing a date column

Hoping someone can help with what I'm sure is a painfully simple fix.

I'm getting INVALID COLUMN VALUE with the following formula. I've researched this error and it doesn't seem like the column type should be anything except text/number.

=SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], IFERROR(MONTH(@cell) = 1, ""))

Thanks in advance


  • Frank Falco
    Frank Falco ✭✭✭✭✭✭

    Give this a try

    =IFERROR(SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], MONTH(@cell) = 1), "")

    What is the type of the column this is in?

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

  • Hi Frank,

    Thanks so much! The IFERROR at the beginning did the trick.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!