Count per month based off created date
Hello,
I'm struggling to get the count of submissions per month. For the submission date I used the "created date" in the drop down options for this specific column. I am not getting any errors with my formula it's simply counting them as "0." For example, June should show a total of 4 submission, but my formula is returning 0. My questions is if you can use the COUNTIF function with this type of column in smartsheets?
My current formula is as follows: =COUNTIFS(Submitted1:Submitted6, "MONTH(6)")
However, I have tried various formulas with the same output.
Best Answer

Hi @kgerholdt ,
One way is to use a "helper" column. Setup another column titled something like "Submitted Month" and use the following formula: =MONTH([Submitted]@row)
Then in another field you can use =COUNTIF([Submitted Month]:[Submitted Month], =6)
You can do this for each month you want a count of.
Hope this helps.
Dave
Answers

Hi @kgerholdt ,
One way is to use a "helper" column. Setup another column titled something like "Submitted Month" and use the following formula: =MONTH([Submitted]@row)
Then in another field you can use =COUNTIF([Submitted Month]:[Submitted Month], =6)
You can do this for each month you want a count of.
Hope this helps.
Dave

@kgerholdt The MONTH() function returns the numerical month when you included the date in the parentheses of the function. Also, functions never go in quotes. The way your formula is written Smartsheet is looking for the literal text value of "Month(6)" and that is why you are getting a count of 0 since this text value doesn't exist anywhere in the range.
Your formula should be: =COUNTIFS(Submitted1:Submitted6, MONTH(@cell) = 6)
Or if you want it to be over the entire Submitted range even for new entries, =COUNTIFS(Submitted:Submitted, MONTH(@cell) = 6)
The @cell operated allows the MONTH() function to evaluate the range row by row.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions

Thank you, both!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!