-
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…
-
View Data Shuttle Status on Dashboards
Is there a way to display current Data Shuttle status and the last time a workflow ran on a dashboard? I'm frequently having to check Data Shuttle to see when a workflow ran last, and it would be useful to have this available via a report, widget, or embeddable content.
-
Merged: Allow Primary Column to be moved in Reports while using Grouping
This discussion has been merged.
-
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…