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