-
COUNTIFS Function of # of Values Used in a Median Calculation for Metric Sheet
I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1))) I now want to calculate in a adjacent column the total…
-
View if sheet is referenced in a report or dashboard?
I am cleaning up the numerous sheets I've created. However, how can I see if the sheet is referenced in a report, dashboard, other? I do not want to delete a sheet that is in use.
-
Published Dashboards - CTRL+F availability
It would be very helpful for users to have the ability to search for keywords on published dashboards using CTRL+F. We use a published dashboard to provide all company help & information for Smartsheet. This helps showcase some of the functionality of Smartsheet from the start. We have multiple sections that we may refer…
-
Attachments sheet to dashboard.
Is it possible to do so that the attachments attached to the sheet would be automatically seen in the dashboard ?
-
How do I get a Dashboard Chart Widget to display 'No Data' when the source report returns no data?
I have a dashboard chart widget whose source data is a report on a sheet. There are times when the report accurately returns no data from the sheet that meets the reporting filter criteria. In that case, the dashboard chart widget displays an 'Unable to display chart' error (screenshot below). This error message is…
-
Dropdown list - when selecting multiple values, maintain cursor at selected value
When selecting multiple values from a drop list, the cursor moves to the window where selected values are displayed, requiring the user to begin scrolling from the top of the list again. It would be helpful if after selecting a value, the cursor remained at the value that was selected, to allow the user to continue…
-
Sticky Notes?
Our group uses dashboards as an overall communication tool for various things, but some type of sticky note (like post its), or an editable "white board" could be of serious use to us. A place to stick a notable topic, or reminder to the team, or an individual, or track a rolling to do list right on a dashboard would be a…
-
Transforming numerical data
The ability to easily transform numerical data on dashboard graphics. I.e. 1.5M, instead of the long string of numbers, when adding labels to graphs, so that it is clearer to read.
-
How can I create a chart that shows your progress towards a goal?
I'm currently struggling with figuring out how to create a chart that shows our team's progress towards a goal. Is there a way to do this with either a pie chart or a bar chart? I want this to display on our dashboard so the team can visually see where we are.
-
Capability to sort charts
It would be great to have the capability to sort the data on the charts on the dashboard. Particularly as I deal with multiple countries, it would be very beneficial to see a hierarchy of data