I want to show only the latest weekly update in my dashboard.
I have a smartsheet used to send out weekly updates to key stakeholders.
I also have a dashboard for all interested to view the project status. I am wanting to update the dashboard with the latest update from the spreadsheet.
on the dash board I want the last entries for issues & incidents/ What was accomplished this week and what will be worked on next week to show like:
But I don't want to have to go in weekly and change the line on the report to show. Is there a way to always show the last populated line of the sheet?
Thank you
Michelle Phillips
Accumen
Answers
-
Is the most recent update always on the last populated row of the sheet?
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!
-
Paul,
Yes it is always the last row of the sheet.
michelle
-
Ok. And how exactly are you currently pulling this data? Are you pulling it into another sheet or using Sheet Summary fields?
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!
-
right now I am pulling the data into the dashboard
using the metric widget
-
Ok. I would suggest creating a new Sheet Summary field for each column of data that you want to capture.
Then you would use something along the lines of the below to capture the most recent data for whichever column(s) you want to pull from:
=INDEX([Column Name]:[Column Name], COUNTIFS([Weekly request]:[Weekly Request], @cell <> ""))
Then set your metrics widget to point at the sheet summary field(s).
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!
-
Great I will try that! Thank you Paul😀
-
Happy to help. 👍️
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!
-
That worked like a charm, thank you again
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives