-
Formulate % Complete for Stages on Dashboard
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 not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Building a Dashboard from external survey
I'm having trouble organizing either a report or a sheet for it to be data that can be read by the widgets in a dashboard. To recap: I sent out a survey to students who had the choice of attending 3 schools. The first question asks which school they attended, then all the following questions apply to each school. I want…
-
Group widgets in dashboards
When moving widgets around in a dashboard it is increadibly difficult to move the order and placement of widgets. While you can select multiple widgets to move them, you can't group them so that they move together when another widget is being moved near them.
-
Merged: Format Text of Chart Series Labels
This discussion has been merged.
-
Can Entries be Added in to the Calendar App from the Calendar itself? see screenshots
When trying to add an entry via this Panel on the Details panel on the right, it give me the error message shown below that. Every time, even in different sessions, refreshed, restarted, etc. Can this be done? If not, is there a workaround for quick entry right into the Calendar?
-
Sheet Summary Metric on Dashboard
Hello, I have a dashboard with a normal metric widget that is linked to sheet summary data from the grid sheet. It works perfectly fine all day, then every morning shows "0" until I open the source sheet, click into the sheet summary tab and save the report. When I go back to the dashboard it is the value it is supposed to…
-
How to share reports/dashboards with the filter on Current User, without sharing the source sheet?
Hello, I'd like my team members to have access to HR information in a Dashboard, but only info concerning them (current user) should be displayed. I created a sheet, no one but me, has access to, listing all my team members. Then, I created a report and added a filter "Team member - Has any of - Current User". Finally, I…
-
Dashboard not showing for shared users
Hi, I've created a dashboard that displays information unique to each user. The reports included in the dashboard are filtered by Current User, and the Widgets are set to "Their own perspective." I am a licensed user and am the Owner of the dashboard, all of it's reports, and the sheets behind them. This dashboard needs to…
-
Individual Customer Report
Hello, I have a smartsheet form and sheet that I have created reports and dashboards on. The form has many submissions from customers. Many customers have made multiple submissions to the sheet. I would like a report that shows how many individual customers have submitted the form. Is there a way to create this? To note,…
-
Charts to show field averages
I have a survey - there are 10 questions that are ratings - symbols 5 stars. I need to create a graph that shows the weekly average rating for each question - prefer a bar chart. I've created a report to filter the data for the last week. I have a dashboard and see the chart widget. However, I can't figure out where to use…
