SUMIF within specified date


Im wondering if there is something wrong with my formula below or something I should tweak. The exact formula below returns values as expected (anything in the [Expected Revenue] Column in the year 2020. When I copy paste to another cell it just gives error messages (I am trying to do the same thing for 2021 but it won't let me). I had a similar problem getting the initial result but just kept playing around with it until it worked even though the end result was no change. Thoughts?

=SUMIF([Expected Install Start Date]:[Expected Install Start Date], YEAR(@cell) = 2020, [Expected Revenue]:[Expected Revenue])


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!