Month Function
Hello,
I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year.
e.g.
| January | 45 |
---------------------
| February| 20 |
However, I am finding trouble actually calculating the amount based off of the creation date. I figured a solution would be to use creation date to extract the month then a SUMIF/COUNTIF to count the amount within a month. Unfortunately, it has only said invalid data type.
Thanks in advance!
Comments
-
Hello,
I used =MONTH to pull the month # from a date column into its own column called MONTH. Then, this seemed to work:
=COUNTIF(Month:Month, =1)
=COUNTIF(Month:Month, =2), etc.
Hope that helps.
Dave
-
Thanks for the response!
It worked out perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!