57NETWORK
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
      • PDPA - Job Applicant
  • SMARTSHEET
    • Try Smartsheet For Free
    • BrandFolder >
      • BrandFolder + SMAR
    • Services >
      • Training For Success
      • Solution Building
      • Add-on Premium App >
        • Microsoft + Smartsheet
        • Docusign + Smartsheet
        • Dynamic View
    • Solutions >
      • Smartsheet For PMO >
        • Control Center
        • WorkApps
        • JIRA + Smartsheet
      • Smartsheet For Accounting Finance
      • Smartsheet For Legal Firm
      • Smartsheet For Marketing
      • Smartsheet For IT Operations
      • Smartsheet For Education
      • Smartsheet For Construction
      • Smartsheet For Healthcare
      • Smartsheet For Government
      • Smartsheet For Non-profit
      • Smartsheet For Software Development
      • Smartsheet For Sales
      • Smartsheet For IT PMO
      • Smartsheet For Professional Services
      • Smartsheet For Media Entertainment
      • Smartsheet For Telco
      • Smartsheet For SME
      • Smartsheet For Retail
      • Smartsheet For Energy and Utilities
      • Smartsheet For HR
      • Smartsheet For Tech Company
      • Smartsheet For Manufacturing
    • Customers Stories
    • Smartsheet Enquiry
  • Blog
  • CYBERSECURITY
    • Ransomware Mitigation
    • Prevent Email Fraud | Email Security
    • Installation Guide | Bitdefender Gravityzone
    • Patch Management
    • Nutanix Integration with Bitdefender Gravityzone
  • CONTACT US

Quick Guide: Best Practices for Building Your Dashboards

4/30/2018

 
by Stephen Branstetter on February 21, 2018

Earlier this month, we revealed Smartsheet dashboards, an unprecedented bird's-eye view into your business's work in Smartsheet. With dashboards, you have a customizable, powerful tool that arms you with real-time data and information for making the best decisions. Let’s look at some best practices for getting started with dashboards so you can improve your work right away.
​

Preparing Your Information for Dashboards

Before you start building a dashboard, there are three factors you must determine. 
  1. Your purpose: Is this dashboard for a single project, multiple projects, or a general information portal?
  2. Your audience: Are you building a dashboard for yourself, your team, middle management, or a C-level executive?
  3. Your data: What data and information will be most useful for your audience?
​
Dashboards are powerful tools for visualizing work across your business, but they can only pull from data that already exists in your sheets and reports. Make sure they are populated with accurate information you’d like rolled up to your dashboard. Everything in your dashboard is gathered from one of the following information sources:
  • Data in a sheet: Quickly consolidate totals and averages from data in your sheets. For any piece of data that you want to include in a dashboard, you’ll need to first build the calculation to figure it in the sheet itself.
  • Reports: You are able to pull a full Smartsheet report into a dashboard. Building a report allows you to display a certain set of rows and/or a specific set of columns, consolidating information across multiple sheets into a single view.
  • Links: It can be extremely efficient to use portals as information hubs to link all relevant documents on a topic. Links can direct to important Smartsheet sheets, external web pages, files, and more.

Determine which of these types of data you already have, and which you still need to create. Once you know what you’d like your dashboard or portal to contain, it’s time to start building.

Remember: You cannot do any calculations on a dashboard itself. Calculations must be completed in your sheets using hierarchy functions or summary sections with formulas at the sheet level. Next, configure your reports. Reports pull in data from your sheets, and dashboards pull from your reports, so ensure you’re only gathering the data you want to show. 
​

Building Your Dashboard or Portal

Once you’ve made your preparations, it’s time to start building your dashboard or portal. Create a dashboard just like you would a sheet or report. 
  1. Click Create New, or right-click in a folder or workspace and select Dashboard/Portal from the drop-down menu.
  2. Determine which types of widgets you’ll need. We recommend using several different widget types in your dashboard to surface all the data you need in a cohesive layout.
  3. When you’re finished planning, start building out your widgets. It’s important to not be too concerned with how they’re organized yet. Make sure they’re properly linking to the data you want before you do anything else.
  4. After your widgets are built and your dashboard is populated, it’s time to organize. Move, resize, and edit your widgets as needed. Remember, your dashboards can be about six widgets wide, but infinitely long.
​

Quick tips:

  • Don’t worry about making your dashboard “pretty” when you first start. Get your data connected to your widgets first, then focus on formatting.
  • The power of dashboards are in their visual, at-a-glance nature. Let the surfaced data speak for itself without trying to reinvent the wheel.
  • Use Rich Text widgets as placeholders to test out sizing and organization.
  • Sketch plans out on paper before you get started.
  • Take screenshots of your dashboard layout before you make changes. If you don’t like your new layout, you have a record of the previous one.
​
Picture

Sharing Your Dashboard With Stakeholders

Once your dashboard is built and surfacing all the data you need, it’s time to share it. To share a dashboard, use the sharing tab at the bottom of a completed page. The power of dashboards are in their flexibility, even after they're built. More than one person can work on a dashboard at any one time. That’s helpful for project managers and their teams building a dashboard collectively. 

There are two levels of sharing on dashboards: Admins and Viewers. Anyone who is an admin can add, remove, and edit widgets and the dashboard layout. Viewers can view all content on a dashboard, but cannot edit or share with anyone else. However, unlike reports, viewers do not require access to the underlying sheets to view their information in dashboards, ensuring an easy way to highlight critical data from both sheets and reports to your audience without showing them everything under the hood.

If you and your team find a dashboard layout that works well for you, you can create a template from it for use elsewhere. Copy a dashboard by selecting Save as New to create a new template that you or your coworkers and clients can reuse. Of course, you can edit all of the widgets to pull from new reports and sheets. Dashboard links will automatically update when someone duplicates a workspace.
​

Quick tips:

  • Have employees get used to adding header rows to their sheets if they plan on rolling up the information under them.
  • Take time to provide report training to employees working on the sheets your dashboards will be pulling from.
  • You can drag a dashboard between folders and workspaces to share with a group of people.

With these best practices, we hope you’ll find dashboards to be as versatile and useful a tool as we do. If you're on a Team or Individual plan and interested in upgrading your plan, contact our team today.
​
Source: Smartsheet Blog
​

    Author

    Writers and Bloggers from Smartsheet.

    Categories

    All
    2019
    360 Reviews
    Abacus
    Accelerate
    Accountability
    Accountabillity
    Administrative Control
    Adoption
    Agile
    Agility
    AI
    Alert
    Artificial Intelligence
    Asset Management
    Authentication
    Automation
    Automation In Workplace
    Autopsies
    AWS
    Barcode Inventory
    Better Communication
    Better Decision
    Borderless Team
    Bottom-Up
    Brainstorm
    Business
    Business Leaders
    Business Moves Fast
    Business Software
    Card View
    Chat
    Chatbot
    Chatflow
    CIO
    Clear Vision
    Cloud
    Collaboration
    Collaborative Work Management
    Comfort Zone
    Competitive Advantage
    Compliance
    Construction
    Converse.ai
    Creativity
    Critical Path
    Cross-functional
    Csuite
    CTO
    Customer Experience
    CWM
    Dashboard
    Data Control
    Data Privacy
    Data Security
    Data Visibility
    Decision Making
    Delegation
    Digital Technology
    Digital Transformation
    Direction
    Efficiency
    Email
    Employees
    Employee Spotlight
    Empower
    Engage
    Enterprise
    EVENT
    Flexible
    Future Of Work
    Gantt Chart
    GDPR
    Google
    Google Hangouts
    Google Maps
    Google Sheets
    Grow
    Hacker
    High Value Work
    Hours Saved
    HP
    Information Access
    Innovation
    Issue Tracker
    IT
    IT Team
    Kevin Carroll
    Killer App
    Location Capture
    Location Sharing
    Logged Locations
    Luca Pacioli
    Machine Learning
    Make Better Decisions
    Maximise Productivity
    Maximum Value
    Meeting Management
    Meetings
    Meltdown
    Messaging Integration
    Microsoft
    Microsoft 365 Tips
    Microsoft Excel
    Microsoft Teams
    Mobile
    Navigation
    New Interface
    Old Systems
    Onboarding
    Permissions
    Phishing
    Portals
    Portfolio Reporting
    Post-mortem
    Praerit Garg
    Productive
    Productivity
    Project Management
    Project Managers
    Project Tracking
    Quality
    Quantum
    Real Time Information
    Real-time Information
    Request Management
    Risk
    SAAS
    SaaS Adoption
    Scalable
    Scam
    SECURITY
    Security Control
    Silo
    Skype For Business
    Slack
    Smart Meeting
    Smartsheet
    Smartsheet Dashboard
    Smartsheet Mobile
    Smartsheet Portals
    SMARTSHEET TECHNICAL
    Spectre
    Speed
    Spoofing
    Spreadsheet
    Stay Connected
    Streamlined Processes
    Successful
    Teamwork
    Team Work
    Technology
    Time Saved
    Top-Down
    Track Submissions
    Transform
    Transparency
    Trust
    Upgrading
    Visibility
    Waterfall
    William Oughtred
    Work Anywhere
    Work Better
    Work Collaboration Platform
    Work Communications
    Work Execution Platform
    Workflows
    Workplace
    Workplace By Facebook
    Workplace Messaging
    Work Smart

    Archives

    December 2022
    November 2022
    October 2022
    February 2022
    October 2021
    September 2021
    July 2021
    May 2021
    December 2020
    October 2020
    July 2020
    November 2019
    September 2019
    July 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    January 2018
    December 2017
    November 2017
    October 2017
    August 2017

    RSS Feed

Malaysian accounting firm CKP improves both sales and productivity 30% by digitizing and automating with Smartsheet


Care line: +603-9212 0157

Leave us your inquiry

Contact us
Picture
Reach us via Whatsapp

Picture
Picture
57Network has been helping global companies in digitizing work management for greater transformation.
Copyright © 2022 57Network Consultancy Sdn. Bhd.
Company Registration number : 202001020346 (1376666-K) 
​(Formerly FIFTY SEVEN NETWORK since May 2015). All rights reserved.
 Privacy Policy ​ | ​Integrity Pledge | Site Map
Designed by 57 Web
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
      • PDPA - Job Applicant
  • SMARTSHEET
    • Try Smartsheet For Free
    • BrandFolder >
      • BrandFolder + SMAR
    • Services >
      • Training For Success
      • Solution Building
      • Add-on Premium App >
        • Microsoft + Smartsheet
        • Docusign + Smartsheet
        • Dynamic View
    • Solutions >
      • Smartsheet For PMO >
        • Control Center
        • WorkApps
        • JIRA + Smartsheet
      • Smartsheet For Accounting Finance
      • Smartsheet For Legal Firm
      • Smartsheet For Marketing
      • Smartsheet For IT Operations
      • Smartsheet For Education
      • Smartsheet For Construction
      • Smartsheet For Healthcare
      • Smartsheet For Government
      • Smartsheet For Non-profit
      • Smartsheet For Software Development
      • Smartsheet For Sales
      • Smartsheet For IT PMO
      • Smartsheet For Professional Services
      • Smartsheet For Media Entertainment
      • Smartsheet For Telco
      • Smartsheet For SME
      • Smartsheet For Retail
      • Smartsheet For Energy and Utilities
      • Smartsheet For HR
      • Smartsheet For Tech Company
      • Smartsheet For Manufacturing
    • Customers Stories
    • Smartsheet Enquiry
  • Blog
  • CYBERSECURITY
    • Ransomware Mitigation
    • Prevent Email Fraud | Email Security
    • Installation Guide | Bitdefender Gravityzone
    • Patch Management
    • Nutanix Integration with Bitdefender Gravityzone
  • CONTACT US