Calculate a total based on Month

Mross0878
Mross0878 โœญโœญโœญโœญ

Hello,

I have had a request to calculate totals by month and by current month for some dashboarding. I am struggling to work with dates and how to separate by month. I don't have a current test formula, but any general notes on how to work with dates easily in formulas would be a great place to start.

Thanks!

Best Answer

  • Mross0878
    Mross0878 โœญโœญโœญโœญ
    Answer โœ“

    Small update - I believe I answered this.

    =SUMIF({Compost Tracker Range 3}, =MONTH(TODAY()), {Compost Tracker Waste})

    The first cross-reference is a column that is pulling the month from a date column using - =MONTH(Date@column)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!