Smartsheet SUMIFS returning a zero value but working correctly on Excel
I am trying to calculate the CO Value if the Date Created in the corresponding rows are Dec-2021.
My CO Value Column is formatted to "Currency" and my Date Created Column is formatted to "Date".
Formula used is as follows:
=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, ">=01-Dec-2021", [Date Created]2:[Date Created]52, "<=31-Dec-2021")
This is returning a €0.00 value.
I have replicated this in Excel and it is working correctly but will not return the correct value in Smartsheet.
Can you please offer a solution.
Best Answer
-
Thank you Genevieve,
That has worked perfectly.
Answers
-
Hi @Dee.M
Your current formula is searching for the text of ">=01-Dec-2021" since you have quotes around this value. If you're looking for a date, you'll want to use the DATE function, try this:
=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, >= DATE(2021, 12, 1), [Date Created]2:[Date Created]52, <= DATE(2021, 12, 31))
Cheers,
Genevieve
-
Thank you Genevieve,
That has worked perfectly.
-
Wonderful! Thanks for letting me know, I'm glad I could help.
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!