linking the same widget across multiple dashboards for 1 update

I have 3 dashboards created that are mostly the same, but have some slight differences based on the team that is consuming the information. I have 2 column graphs that are identical across the 3 dashboard that pull metrics from a metric sheet. The column graphs is showing monthly team capacity on a rolling 6 month basis. Each month I need to update the source data. I realized that smartsheet doesn't keep settings with source data changes, so each month I have to make the following changes to each column graphs. That is 6 graphs in total (2 charts x 3 dashboards)

  1. change the source - I typically move the month that passed to the end of my metric doc and then have to select the next 6 months. So I have it set up with each column as a month and if I am updating in November, I am moving Septembers column to the end.
  2. smartsheet defaults to line so I change to column graphs
  3. The widget also has widget behavior to show a click down report of each team member that the capacity rolls up to. I have to relink the widget behavior.

This is really not sustainable. So my ask is is there a way to link these widgets so that updating one dashboard will update all the others? We have an enterprise license and do not have control center.

Or for you genius smartsheet guru's is there a better way to set myself up so lessen the work?

Thanks!

Answers

  • ChristianFinke
    ChristianFinke ✭✭✭✭✭

    Hi @KathrynEK

    Unfortunately, Smartsheet doesn’t have a way to link widgets across multiple dashboards for simultaneous updates without Control Center.

    I am assuming you don't have Control Center as you would be able to do this with Control Center. If you would be interested in adding control center please let me know!

    If not, I would try to create a master dashboard or use dynamic reports.

    Best,

    CHRISTIAN FINKE

    cfinke@digitalradius.com

    Schedule a Meeting