Dashboard - Formula help for date fields

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

Hi

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.

Capture.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!