-
Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…
-
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?
-
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
-
Dashboard Bar chart
I want to show how many request have come each week and show this value on a Dashboard with a bar chart ? I also need to show the oldest request that has a value of "New Request" maybe put this value on a Card of Text area on the Dashboard ? Any help would be appreciated...
