-
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.…
-
Search functionality / widget in Dashboards
The search functionality within widgets on Smartsheet dashboards does not exist, and we have not seen that CTRL+F is reliable enough. In order to increase user experience with dashboards, we'd like there to be a widget search option that will search for text within any widgets on the dashboard.
-
Gantt Chart misalignment on Dashboard
I've noticed that a Gantt Chart that I have displayed on my Dashboard doesn't align properly. Headline tasks get progressively more and more out of alignment on the right-hand side. See below for a demonstration. Any thoughts on why this would be happening?
-
Dashboard Sharing - Security
Hi... When publishing a dashboard, is there a way to imbed security so only certain users are able to view without having to sign up for a free account? Managing a large group of users will be overwhelming for our current team and we are trying to rollout information to unlicensed users. Thank you!
-
Editing in progress suggestion
Hello, I have been using Smartsheet for many years and have built many solutions. Over the past year, my role has been to develop solutions in Smartsheet as we've launched a new department. With a new department, we have many new processes to develop and many "firsts". With so much innovation embedded in our processes, our…
