Dashboard question- Can I add a list of locations to click on and all of the widgets update?

09/20/21
Answered - Pending Review

Like in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Krystal Garcia

    I hope you're well and safe!

    Unfortunately, it's not possible now, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Here's a possible workaround or workarounds

    I recently developed two different solutions for a client (both are relatively advanced)

    • Select the criteria in a form and submit, and that opens the dashboard with the updated metrics/reports and similar.
    • Select the criteria in either a so-called master metrics sheet or similar and update the dashboard to show the selections

    Would any of those options work/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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.