Dashboard - Formula help for date fields

edited 12/09/19 in Formulas and Functions


I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all different dates) please can someone provide the formula that will allow me to make a count of how many actions for May?

The eample attached, shows 5 actions that have been executed in May. On my dashboard I want to show 'Offers Accepted in May' to generate the count of 5.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!