Show Current or Last Week Update comments on Dashboard
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:
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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 :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!