Formula to count volume based on month

Options
HarryS
HarryS ✭✭
edited 06/22/23 in Formulas and Functions

Hello,

I have a column that captures the month each time a form is submitted. I would like to create a summary formula that allows me to track the volume received each month.

Any help would be appreciated!

Also, will the single formula be able to track the volume for each month separately or will I need to create a new summary field/formula for each individual month? (i.e. Summary field 1 with formula for January, field 2 for Feb, etc)

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    If you want to be able to view each month's counts separately then you will need separate fields, but if you just want current month then you would only need one formula.


    =COUNTIFS([Submission Date]:[Submission Date], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))


    The above will give you January 2023. TO change it to current month/year, you would replace the month and year numbers with MONTH(TODAY()) and YEAR(TODAY()).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!