Pulling data from 1 sheet into multiple dashboards

Rajnandini Agrawal

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?

Marlana K.

@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 K.

@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

Rajnandini Agrawal

Hi @MARLANA KALINOWSKI

Thanks for the response. This was very helpful.

Marlana K.

@Rajnandini Agrawal You are most welcome, always happy to help.