Rolling metric data sheet for chart that is current month and last 13 months
I'm trying to setup a metric data sheet that will automatically roll (update) without constant manual intervention. I don't believe I'm doing this right. We have multiple different types of task and I'd like a count by month of each that are In Progress.
I want to show this data in two charts on a dashboard:
- a bar graph of the current month's task types | counts
- historical line graph of the past 13 months (columns: 1 mth thru 13 mths) task types | counts
I am using a helper column (TODAY helper) instead of just TODAY(); I have a workflow automation rule that updates this daily.
I keep getting #INCORRECT ARGUMENT SET or #INVALID DATA TYPE. All my columns are text/number except the TODAY Helper - that is a date column.
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!