Dashboards

Ellen,

I may be a little slow, but something tells me you want the dashboard to be colorful. 

SS is rolling out some enhahcements to the Dashboard hopefully before the end of the year.  Maybe it will include what you are asking for.

Here's all the product road map says. https://www.smartsheet.com/product-roadmap 

 But I received a survey from SS 3-4 weeks ago and although I'm not sure about the colors, it may be able to do the functional project tracking you are wanting. And in talking with support, they referenced it will be a great tool to do project tracking.

For single projects there is an app that integrates with smartsheet that may help you create colorful reporting status.  https://www.smartsheet.com/apps/officetimeline

Tim

Tim is correct, improved dashboards are coming! I dont have any details I can provide at the moment but we are working hard to get this released by the end of the year. 

Hi Tim,

Our first release of dashboards will support 6 different widget types. Based upon customer feedback we are trying to solve three key problems. First is surfacing key metrics from sheet data and second is easily navigating to the right sheets and reports and third and surfacing additional content that might be relevant to the data in the sheets.

Here is an example; we have a customer that uses Smartsheet to organize all of their HR data. It includes, PTO requests, employee lists, department contacts, etc. All of this data is distributed across many different sheets and there is even a sheet that describes all of the data in the other sheets. With our new dashboard functionality, they will be able to have a dashboard that summarizes metrics like number of employees, upcoming holidays, links to a form to submit a PTO request as well as links to the employee handbook and other important HR resources. This is not your traditional dashboard but it is a very useful dashboard for surfacing and navigating information in Smartsheet.

Another example is a project portfolio dashboard. Based on data in sheets I can highlight total number of projects in the portfolio, how many of those projects are on track, a project level report with Gantt showing start and finish dates and much more. This dashboard could include links to the detailed project sheets or links a project charter document in Box. These are just a few examples.

One thing to note is that in the first release there will not be charts. We are working on this capability but they will not be ready in time for the first dashboard release. Based on customer feedback there is so much value in the 6 widgets we are releasing it was not worth waiting for the charts widgets. I am happy to answer more questions if you have them.

Scott

Thanks for the reply Scott.

Agree w/ Tim. This new functionality will get us much closer to where we would like to be.

We are preparing now for a year-long implementation project that is scheduled to kick-off mid Feb. Any chance the dashboard capabilities will be in place before then?

Thanks,

Tim

Us Tims are good at keeping secrets.   And of course Ellen was what got this whole conversation going.....

Hello Scott Fuller, It is will certainly add more capability of SS with dash board. Do you have plans to cover Business Intelligency tools?  I mean each sheet and report can be configured for business intelligence and analysis by user / editor. If required,  we can discuss further on this.

Kapil,

To answer your question about BI tools.  It is our goal to be able to provide visualization and basic analytics within our dashboards.  These capabilities will not all be in V1 of dashboards but we will continue to expand what our users can do with Smartsheet Dashboards.  We are not however trying to create an advanced BI tool like Tableau or PowerBI.  For our users with more advanced analytics needs we offer integrations via our live connector or via direct in app integrations.