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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!