Show Current or Last Week Update comments on Dashboard

jedelman

I'd like to show Weekly Updates and Last Weeks updates using the Metric Widget on my Dashboard. I've been searching and it seems like Sheet Summary is my best bet.

I've tried the solution below but I'm not seeing any text from the column when using the formular:

https://community.smartsheet.com/discussion/79679/i-want-to-show-only-the-latest-weekly-update-in-my-dashboard

Andrée Starå

Hi @jedelman

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jedelman

Hi @Andrée Starå,

Apologies for not giving more details.

I prefer the presentation of a metric for updates rather than a Report on a Dashboard. I want folks to see what last week's update was and the current week. I have a formula in my source sheet that just checks the box for Last Week or this Week based on a date column of Week Of.

To make my life easier I have the Week Of column populated out until the end of next year. I have an automation setup to send me a Update Request on Friday's for the upcoming week. I then fill out the details of the Update and Plans for next week. I want those to automatically update on my Dashboard rather than having to go in to the Widget and highlight the appropriate row every week.

Pictures of the Sheet and ideally how the metrics would look on the Dashboard.

Thanks for any help :)