-
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…
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
How to create a dashboard metric widget to automatically obtain the data template？
Dear friends, I am using the dashboard metric widget to obtain data, but I have not found a way to reuse it, it cannot use functions. I can create a new project form through a template, but when I use the dashboard, I have to re-select the data source. To obtain data for a new project, is there any good method to suggest…
-
Guage Chart or Speedometer Charts
I couldn't find a gauge chart option in Chart widgets, any idea if it is available or any work around? It is strange - as this is very basic chart other apps/ Software provided for their Dash boards. Seems Customization is not an option in Smartsheet, I mean ever Excell can create a gauge chart.
-
Dashboard widget flexibility
Hello Is there top show a subset of tasks from a project plan on a dashboard and ONLY have the end date filled in once marked a 100%? I made a report of the subset of tasks but I am unsure if it is possible to not include the date until it is 100%. Maybe a report is not the solution, but if there is a way to do this report…
-
Question on Metric Sheets and COUNTIFS formula
Hello! I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did! Here is my formula: =COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2) And here is my table:
