Month Function

cjleon
cjleon
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!