Month Function

edited 12/09/19 in Formulas and Functions


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. 


| 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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!