-
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…
-
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:
-
How to generate a report for duration (sum hours) to generate a widget.
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number of rows with data entered. Is there a way to generate this data to extract to a widget for a dashboard?
-
Axis customisation on graphs
Anyone else frustrated with auto-generated axis values? For example, when I graph items with <10 entries, there is almost always a decimal place. This doesn't make sense for items like "number of reports". I can't have .25 or .5 of a report. I'd like to see at least a toggle button to whole numbers only. Would love to see…
-
Using cells in a reference for a metric sheet
Hello! I am quite new to smartsheet and had a questions about some widgets. When referring to another sheet in my calculations sheet, I want to refer to a set of cells in a column instead of the entire column. However, I want it to update based on new info entered in the column. Also, anytime the sheet is sorted, it makes…