Count per month/year automatically

What formula do I use to count data per month/year and have it update automatically with new entries. How do I pull that rolling  data for past 12 month data to dashboard 

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Lynn Collier 

    Hope you are fine, please find in the following the formula to count by month for November for example

    =COUNTIFS([Column2]:[Column2], <=DATE(2020, 11, 30)) - COUNTIFS([Column2]:[Column2], <=DATE(2020, 11, 1))

    and if you want count for 2020 you can use the formula

    =COUNTIFS([Column2]:[Column2], <=DATE(2020, 12, 31)) - COUNTIFS([Column2]:[Column2], <=DATE(2020, 1, 1))

    check the following screen shot for the sample


    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Lynn Collier 

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Hi, Sorry for the delay in getting back to you. The first formula works so that I do not have to put in a filler column of first and last day of the month. Thank you Lynn

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!