I'm working to build a dashboard that presents monthly metrics. I want the dashboard to automatically update to display the last 12 months' metrics. I have a metrics spreadsheet that calculates all the information for each month.
I'm wondering if the best way to achieve this is to create a new smartsheet with a formula to calculate & populate the last 12 months and then using index/match (or some variation of that) to pull data from the original metrics spreadsheet or instead to create a report that pulls data from the metrics smartsheet, is filtered by date within the last 365 days (or something like that).
What would the pros and cons be of each? Is there a better option I'm overlooking?