Average times by month

Hi. I am working on creating metrics for my dashboard, but I'm unable to figure the correct formula for collecting the average call times per month, with the month being pulled based on a date column.

All of the data is in another sheet called OHCA Form including the date and the calculated time difference per incident in that same OHCA Form sheet.

For the row called "Time from 911 call to CPR instructions given", I have this formula in the January cell:

=AVG(COLLECT ({OHCA Form - Time CPR instructions started}, {OHCA Form - Incident Date}, MONTH(@cell), =January$1))

Where I want the OHCA Form - Time CPR instructions started averaged if the incident date is January; however, I receive an #unparseable error

What am I doing wrong? Any ideas would be greatly appreciated!!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!