Automated Dashboard Metric Updates
I have a dashboard for one of my projects where I use a metric widget to share updates on each objective. I have an underlying sheet that sends out update requests every two weeks to the leaders of each objective. I have an automation within the sheet that archives old updates to an Archive sheet.
I want the latest update from the Updates sheet (top row) to be automatically populated into my Dashboard's metric widgets, but once they get archived, instead of having the next row (the new Row 1) show up in the Dashboard, the widget displays a "Missing Data" error.
Has anyone solved this issue before?