-
Need to pick the right solution to start a project. Need Dashboard that receives updates...
Hi All, I am new to Smartsheet and need to setup a new project. I've been told the stakeholders want to view a dashboard that updates from Task Trackers from various departments. It is a large project with HR, Payroll, Tax and Insurance, Finance and Information Technology all doing a piece of the project with their own…
-
Dashboard Report Metrics - remove column headers
Hey Brainstrust, I am wondering if there is a way to remove the report column headers from a report metric on a dashboard. We add our own hearders into the grid so we can change the formatting of the column headers (centre, change colour so they stand out etc). But obviously this looks a bit odd when there are 2 sets of…
-
Dashboards + iPads
More and more executives are working off of iPads (only). Unfortunately, viewing dashboards from an iPad is a very different (materially worse) experience than what one sees when viewing from a laptop. As a result, I am reticent to share dashboards with BOD members and major investors because the charts and graphs look as…
-
Dashboard Funcionality
Hey, friends. Long time listener; first time caller. I'm stuck. Here's what I'm trying to do. I have created a stacked column graph that shows a scale of potential values in several different categories. Example: for "Blue", 0-68% is poor, 69-75% is acceptable, 76-85% is good, 86-100% is exceptional. Then there are…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
Portfolio Metrics and Dashboards
Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake sheet) creates my weekly status report template. Any reason you guys can think of that would make all of my formulas freak out…
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")
-
Chart Widget on dashboard
Hello, I have created a report in order to create a chart widget in a dashboard, which I did, but because the variables are 2 large categories, this looks very big and it doesn't look good on the dashboard. What I would like to display on the chart widget is how many types of transactions are by location since the…
-
dynamic dashboards
hi, I am trying to make my dashboards dynamic ; I am using a form where a choice is made via a drop down menu, then the user submits the forms and via a formula in the background (in a sheet), the dashboards data are updated. This works well but requires about 20 seconds to update. Is there any other way to accomplish this…
-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…