SUMIF? Question
I am trying to write a formula to sum up numbers within the last 30 days in a sheet summary. So my argument =SUMIF([Entry Date]:[Entry Date], ">" TODAY() -30,[House Holds Served]:[House Holds Served]). Honestly I am still very new to formulas and have gone through the Academy online for this step but it is still showing as unparseable. You guys helped me with my last question and I figured this would be easier to figure out but it is not.
Answers
-
You don't need quotes around the greater than argument.
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!
-
Ok I took out the quotes and now receive a invalid operation.
-
Ok. Let's check the column types. Is the [Entry Date] column a date type column, and how exactly is it populated?
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!
-
I figured it out so. My Date column was a text column not a date. Once I switched it to a date it works perfectly. Thank you for your help
-
Happy to help. 👍️
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
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!