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])
Answers

Can you copy paste the exact formula from the sheet that is giving your error message(s) along with exactly which error message(s) you are getting?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

The exact formula above works in one cell but not when I copy paste to another. It will return unparseable

What column is the formula in and which column are you pasting the formula to?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Both are within Sheet summary. I am trying to sum all expected revenue for 2020 and also 2021. I finally got it working but simply by retyping the same things multiple times. Wondering if im doing something weird or maybe there's a glitch?

It seems like there may be a bit of a bug in the sheet. You may want to reach out to support to see if maybe there is something they can refresh on the backend to keep it from happening.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!