Automated Dashboard Metric Updates
Hello!
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?
Best Answer
-
You could use formulas to pull in the most recent entry into Sheet Summary fields and then reference the Sheet Summary fields in your Metrics Widget.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You could use formulas to pull in the most recent entry into Sheet Summary fields and then reference the Sheet Summary fields in your Metrics Widget.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Oh! I have not done this before! Thanks so much!
-
Happy to help. 👍️
My suggestion for a formula would be along the lines of...
=INDEX([Column Name]:[Column Name], 1)
Since you aren't' using a cell reference, you don't have to worry about it running into the same issue when the rows are moved. The INDEX function is basically saying to look a the entire column and pull from the first row.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives