Need help with =SUMIF in summary report
I'm trying to get a sum of time spent for week ending date 7/31/20. This formula gives me a total of zero. Any suggestions for what I'm doing wrong? I've tried the date with and without " ". Thanks!
=SUMIF([Week Ending Date]:[Week Ending Date], ="07/31/20", [Time Spent]:[Time Spent])
Best Answers
-
Hi @laura.buchanan ,
in your formula you try to compare the text string "07/31/20" with a date and that does not work.
Try this:
=SUMIF([Week Ending Date]:[Week Ending Date], =DATE(2020, 7, 31), [Time spent]:[Time spent])
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Since you're looking for a date value, you'll want to use the DATE function so that the formula can read your Column Type correctly!
Try this:
=SUMIF([Week Ending Date]:[Week Ending Date], DATE(2020, 7, 31), [Time Spent]:[Time Spent])
Cheers,
Genevieve
-
Thanks so much for the great feedback! Working now!! :-)
Answers
-
Hi @laura.buchanan ,
in your formula you try to compare the text string "07/31/20" with a date and that does not work.
Try this:
=SUMIF([Week Ending Date]:[Week Ending Date], =DATE(2020, 7, 31), [Time spent]:[Time spent])
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Since you're looking for a date value, you'll want to use the DATE function so that the formula can read your Column Type correctly!
Try this:
=SUMIF([Week Ending Date]:[Week Ending Date], DATE(2020, 7, 31), [Time Spent]:[Time Spent])
Cheers,
Genevieve
-
Thanks so much for the great feedback! Working now!! :-)
-
Pleasure
greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!