-
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.
-
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…
-
Allow Primary Column to be moved in Reports while using Grouping
When grouping data on a report, the primary column becomes locked in the first column position. This becomes a problem when trying to utilize the "Use first column as series labels" option on the Chart Widget in Dashboards. I want to group data by week in my report, and have the week appear as the labels on the x-axis of…
-
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…
-
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…
-
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")