-
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…
-
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…
-
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…
-
Dashboard Report view not showing correct Primary Column values
Have many reports pulling from a master sheet which are functioning correctly. But when this report is viewable on a Dashboard, the preview window is not showing the Primary Column values...? In fact, the dashboard report preview is showing a duplicate of a different column values in place of the correct Primary Column…
-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
-
Dashboard Bar Chart from One Row of Data
I am working on a dashboard (newbie) where I have a table of data in my metric sheet but I need to graph each row independently in a bar chart. My challenge is that, after the first row, I get multiple rows of data displayed in my bar chart when I window the headings and the row(s). How do you choose the row from the range…
