Metric Widget
Discussion List
- 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 ex…
- 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 wa…
- 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 n…
- 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…
- 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 po…
- 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 Wor…
- 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…
- 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 repo…
- 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 entir…
- Hi there! I'm pretty new to Smartsheet, so wondering about an (apparently) missing feature. I'm aware that in Sheets, multiselect columns options appear in a grey background. The challenge I'm experie…