Count the number of submissions received each month year over year

Options

I am looking for help creating a formula to count the number of form submissions in each month year over year. Ultimately, I would like to compare if the number of submissions differs in corresponding months year over year. I have Created (Date) column types which I think will help. I've tried using the MONTH() formula and summing, but end up counting the total number of times a submission is received in each given month appears vs the total number of times a submission is received each month for each year. My form has been in use for multiple years. Thanks in advance for any help!

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Are you able to provide a screenshot of how you want these counts structured?

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Lorraine Metler

    I would go down the MONTH route as well, however you could add YEAR to this so your groupings are more accurate. Try something like:

    =IF(MONTH(Created@row) > 11, MONTH(Created@row), "0" + MONTH(Created@row)) + " - " + YEAR(Created@row)

    This should give you an output that's formatted:

    01 - 2022

    The reason I added the 0 is so that then you can use a Report to Group and Summarize by this helper column and the months will appear in order (01 should then come before 11).

    Let me know if this makes sense and works for you!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!