Pulling data from 1 sheet into multiple dashboards
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
-
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
-
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
-
Hi @MARLANA KALINOWSKI
Thanks for the response. This was very helpful.
-
@Rajnandini Agrawal You are most welcome, always happy to help.
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives