Pulling data from 1 sheet into multiple dashboards

Rajnandini Agrawal
edited 01/12/24 in Smartsheet Basics

Hey Community,

I have a question related to dashboards. I have a master sheet and based on the master sheet I have created multiple dashboards tracking data of different projects in different countries. Now that master sheet gets updated every month and I want that data to automatically get updated in the dashboards too. Is that possible?

Best Answer

  • Marlana K.
    Marlana K. ✭✭✭✭✭✭
    Answer ✓

    @Rajnandini Agrawal

    This will depend on what you are tracking and how. Using Report widget will allow you to display reports which update automatically as things in the sheet change. You can also use the chart and metrics widgets that all update based on a key metrics sheet or the sheet summary. Your key metrics are based on formulas most use COUNTIF or COUNTIFS.




    If you have access to Smartsheet University there is a learning path Communicating with Dashboards- Self Paced if not you can go to this link and learn more about dashboards https://help.smartsheet.com/topics/Dashboards.

    Hope this helps answer your questions.

    MARLANA KALINOWSKI


    MARLANA KALINOWSKI

    Sr. Business Analysts / Smartsheet Solutions

    National Pharmacy Services | Genoa Healthcare

Answers