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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you Genevieve,
That has worked perfectly.
-
Wonderful! Thanks for letting me know, I'm glad I could help.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!