-
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…
-
chart - create % of task per assigned to
Hi I have a task list sheet where I assign user to tasks. Those tasks are marked as In progress, Complete, Not started, etc... I want to create a widget on the dashboard that will display something like the screenshot attached. Being new to Smartsheet, can someone provide me step by step instructions on how to achieve this?
-
Remove the need for duplicate reports in a dashboard
I have a sheet listing data from several different projects and would like separate dashboards created based upon the project data in the sheet. I can do this easily for one project and just add a filter for "Project = ##" to pull in a specific projects data. However I now have the conundrum of creating about 10 different…
-
Move a Dashboard to a New Workspace
Hi - I need assistance with moving an existing Dashboard to a different workspace because people outside of the original workspace need access to it. It was filed under a few folders under workspaces and it got moved to "Sheets" general folder and now some of the connections don't work. Is there a way to leave it where it…
-
Basic Question: How Do I Add ROWS to show in a Dashboard
I feel dumb, but I can't figure out how to add up the total rows and get them to appear as a metric in a Dashboard. It's a complaint ticketing system, as a new complaint comes in it adds a row. As the rows add up I want that number (row total) to add up in the dashboard, as the ticket is cleared I want it removed. How do I…
-
Size of banner for dashboard
Hello everyone, I'm currently working on setting up a Dashboard and I'd like to incorporate a banner at the top, much like the one shown in the example. Could anyone provide guidance on the specifications needed for creating such a banner? Specifically, about the ideal size, recommended file type, and preferred resolution.…
