Struggling with a SUMIFS date range formula

Kelly Gabel
Kelly Gabel ✭✭✭✭✭✭

For this use case, I need to sum the total hours (Range 3) for every entry that has a date between January 1, 2021 and January 31, 2021 (Range 1).

The formula I have seems close but is still coming up as Unparseable.

Ideally, what I want is an evergreen formula that can be applied to every calendar month in the year.

Here is my existing formula. Help please! @Paul Newcome tagging you as always as you are the formula guru!

=SUMIFS({Daily Log Tracker - Template Range 1},{Daily Log Tracker - Template Range 1}, >=1012021, [{Daily Log Tracker - Template Range 1},<=13121], {Daily Log Tracker - Template Range 3})

Kelly L. Gabel


Tech-Savvy Academy

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!