-
Dashboard - I didnt know this!
I have been using Smartsheet for years - and I am shocked that I am 1 day-old when I found out that this feature exists. Clicking on the legends will change the charts and graphs accordingly! Oh well - learning something new everyday (and this is what I love about Smartshweet!) Do you know any other cool features on…
-
Dashboards: Show 'Assigned to' count for each user
Hi, I'm new to dashboards. I want to show the workload assigned to each person. My 'assigned to' column has several names for every row. Am I correct in thinking I need to create a copy of the basic report, filtered to each user so that these can be linked to individual widgets on a dashboard? Any advice would be…
-
Current User Report on Dashboard - NOT SHARED
Today if you are using a Current User Report on a Dashboard you have to be shared to the source sheet. If I don't want people to see the data, there is no easy solution. Please allow the current user report to work by filtering in for view on the dashboard, not source data. Dynamic View doesn't have all the features of a…
-
Merged: Create "Current User" charts on dashboard without sharing underlying data
This discussion has been merged.
-
Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
-
Charting Occurrences Over Time
Hello all, Quick question about setting up a chart widget to show instances over time! I've made a set of sheets and reports that feed into a dashboard to help visualize occurrences. I'd like to add in a chart widget that shows these events over time; nothing fancy - a simple line chart or scatterplot style would be great.…
-
Custom Legend order on a Pie Chart in a Dashboard
Does anyone know how to create a custom order for the Legend that is shown on a Pie Chart? I need it to be in this order: Close Execute Plan Initiate On Hold I know the order is based on the underlying report but I can't figure out how to customize the order. It only does ascending/descending. Any ideas would be greatly…
-
Dashboard Metric Breaks on Update of DataShuttle
I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and says Data missing even though there is data in the field. Is there anyway around this or does Data Shuttle always break a Metric Cell?
-
Dashboard Image Widget Data Source via cell from Sheet
For the Image widget type, expand ability of where to select the data source from to include option that matches that of the Metric widget - where you can choose a cell from a sheet. When using a workflow via Control Center, we intake Clients and capture their logos in a cell (as there is a nice option to insert image to a…
-
Report Filter not available
When I create a workapp to show a report the filter is not available to the user, but the sort is. How do I get the filter available as well? Workapp Edit Mode Workapp Preview Mode