-
Can you create a chart on a dashboard with blank rows?
I have a metric that will report, month over month, new values as they are calculated and added to a sheet. There is an automation that runs each month to copy the current metric row, and place it in a historical sheet. The challenge is that the chart must be re-configured every month to include the new row. Is there any…
-
Metric Widget on Dashboard not pulling symbol anymore
Hello, I am hoping someone can help me to understand why I am getting an error now with my metric widgets in on a dashboard. Previously I was pulling a sheet summary into a metric widget that would show a "symbol" on the dashboard. Now it is showing an image error symbol and not pulling this through to the dashboard…
-
Easily Navigate to Dashboard Widget Data Source
I often have to navigate to the data source of a dashboard widget to make updates, however there is not a direct link to the data source, and sometimes the naming of the source does not make it easy or clear to find. It would be very helpful if there was a button next to data source to "Open Data Source in a New Tab" or…
-
How to make Metric Widget Align the Data?
I have a metric widget to display the number of submitted items. But it drops the value below the line of the field title. I have manipulated font size, removed the widget and re-constructed … to no avail. What am I missing? Thanks in advance!
-
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…
-
Metric sheet filter for Dashboarding
Hello: I have a Metric Sheet that I use to feed data into a stacked column graph in the dashboard. The Metric Sheet has rows and rows of data each with a Totals column. For those rows with 0 in the Totals, I exclude them in the data for the stacked column graph. I've tried to apply a filter which removes the 0's so that…
-
Need Help with a Formula to Help Generate Chart Widget in Dashboard
Hey Folks, I'm trying to create a Chart Widget to show Metrics for how many lines are down due to specific inoperable Status type and thought I had this worked out but am struggling to generate that formula to do just that. So in essence, pull in a Count that references a specific building for how many of any Status type…
-
Widget Behavior Open a Form
Hello Smartsheet, improving the widget's functionality to directly select the Smartsheet Form Name instead of the Form URL would greatly enhance efficiency, especially in Control Center project creation. Currently, Control Center doesn't capture the exact link due to it being an external link, leading to frequent updates…
-
Dashboard widgets not working - April 15th 2024
My dashboards using the Metric Widget are not working I get an error message "Source sheet unavailable". This is consistent with my dashboards set up in this way. The error is the same one that was experienced earlier in the year. Is anyone experiencing the same error?…
-
Formula to list all projects that asked for additional funding and count number of times
All, I want to do the following, if it is possible, for metrics that I need to include on my Smartsheet dashboard. I have tried variations of =COUNT(DISTINCT(COLLECT without success. Here is what I want to do: In a metrics sheet, I want to go to my "2023 IAP Tracker ELT Approvals" sheet, then automatically list all of the…