Help with sumifs and date field

I have a formula that was correctly returning the sumifs of a column (gross) based on the deposit date in 2022 if in the current calendar month. Beginning this year, it is no longer returning data from this month. Not sure what is wrong. Here is data.


=SUMIFS({Gross Commission 1}, {Deposit Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Agent 1}, [Agent Name]@row)

Any help appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!