Assuming that the event date is in the column named, Date_Event, your count of events for the month of February would be...

= COUNTIF( Date_Event:Date_Event, MONTH(@cell) = "2")

For March, it would be...

= COUNTIF( Date_Event:Date_Event, MONTH(@cell) = "3")

..and so on.

Hi, @Hawk23, use COUNTIFS() because you're evaluating more than one range--{Last Date of Employment} and {Term Type}.

Assuming that the range [Last Date of Employment]:[Last Date of Employment] is {Last Date of Employment} (and the same for "Term Type"), the formula would be...

= COUNTIFS({Last Date of Employment}, MONTH(@cell) = 1, {Term Type}, "Resignation")

Hope this helps!

You'll additional documentation on Smartsheet functions at:

Functions List | Smartsheet Learning Center

https://help.smartsheet.com/functions

Smartsheet includes common functions found in most desktop spreadsheet programs. Here's the complete list including definitions and examples.  

@Toufong Vang

I think I found a solution, I added a hidden column into my reference sheet to calc the month based on date, and then used that as the reference in my metrics sheet and it seems to be working.:)