Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables).
Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of tasks remaining; sum of open issues, etc.
Answers
-
The one best practice that I would recommend is to be consistent with your sheets, especially if you plan to reuse dashboards you create for future projects.
Once I created the sheets I needed for a project, I created the dashboard and saved the folder structure to be used as a template.
I've attached a dashboard that I'm using for a project that I just kicked off. This dashboard, all of the underlying sheets and reports, took about 5 seconds to create simply by selecting the saved folder and doing a save as new. The attachment also contains some notes for your reference.
Hope this helps...
-
Thank you, this is really helpful!
Is there a "best practice" for how you built the project plan sheet to populate the project and schedule widget?
-
How did you change the look of the report to resemble a notepad?
-
It looks like this Report is based off an underlying sheet that has a Yellow background applied to all columns/rows. Then the Report is put on the Dashboard using the Report widget.
Let me know if that makes sense or if you'd like to see some screen captures on how to set that up!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Thank you. It wold be nice if we could format reports instead of relying on the formatting of the sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!