-
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…
-
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...
-
Slice data in dashboard
like to slice data similiar to powerBI by clicking on the chart - Drill-down on Pie charts, Battery charts, and Calculation cards to break down the data you're looking at natively by clicking directly into any slice, segment, or number.
-
Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
-
Dashboard and sheet chart graphics for ADA / color blind
I would like to have options other than color for reports/graphs that show texture on charts instead of color. This would help those who are color-blind read the data in a better format.
