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 back-end 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!