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

  • Andrée Starå
    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!

    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.

  • jedelman
    jedelman ✭✭✭
    edited 11/07/22

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!