"SUMIFS" with "AND" and "@cell" combination returning wrong value


Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31)

The following formula returns returns incorrect value:

=SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row))

But, the following formula returns correct value:

=SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= DATE(2020, 7, 1), @cell <= DATE(2020, 7, 31)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!