-
Sharing a Sheet with a Filtered View
I have created a dashboard with multiple KPIs that are sourced from a sheet that contains all of the raw data. I want to have the user be able to click the KPI widget and view the data that falls under that specific criteria. I have multiple filters set up on the sheet with the raw data, and have linked each KPI widget…
-
Global Update to Dashboard
We have a number of projects that are being tracked. I made a change to the dashboard template, but now want to update the existing project dashboards to reflect he change. Could someone please give me instructions on how to do that? When I go to the Control Center and select "Update Dashboards" it does not work. I am…
-
How to link a Workload Planning View to a Rollup/Dashboard
Hi , how do I link this info (tab on the RHS of an Intake sheet) to a dashboard in a workspace? IE I want the Gant view of the Workload planning in my Dashboard.
-
Chart from Metric sheet
Hi all! One of the projects I am working on is using a metric sheet to roll up information. When I create a report from this, to then display on a dashboard, the report shows the column headers. Being a metric sheet, the column headers are generic (Column3, Column4, etc.) as the data within the column varies based on which…
-
How can I align and/or centre my widgets on a Dashboard?
I have about 20 different widgets on a dashboard. I'm looking for a way to easily align selected widgets without having to count how many grid squares are between them. I'm thinking about the function in Visio or Adobe that lets you highlight a number of items and then align them by top, left, right or centre. This issue…
-
Stacked Bar Chart Labels Unable to Show Negative Values
I reached out to Smartsheet support regarding a labeling issue I encountered. When displaying data in a stacked bar chart (example on right), data labels do not appear for negative values. I can only get the negative values to appear on a regular bar chart (example on left). Per the support team, any combination of columns…
-
Need only whole numbers in vertical axis of Dashboard chart widget
I am tracking items that should only ever be between 0 and 10 at the most, however when they are plotted on my dashboard widget (see below), it shows 0.2, 0.4, 1.2, etc. These will only ever be whole numbers (0-10) and are pulled from a count on my main sheet. How can I remove the non-whole numbers?
-
Dashboard and Widget Action
When creating a dashboard, I have been creating charts and linking to reports using the widget action “open another site” and using the report link. The reason is my team prefers to have the report open in a new tab. Currently, I’m going into each report and adding view access for each user. I have several reports in each…
-
Is anyone else losing their mind over the changes Smartsheet is making without announcing it?
I don't understand why Smartsheet changed these icons? They no longer match what is used in a Workspace or Folder. When I teach Smartsheet, I use the icons (sheet/grid, report, dashboard, template, folder, workspace) to help people understand at a basic level what Smartsheet is made up of. THESE make absolutely NO sense…
-
Department specific Dashboards and manual updates to Reports
I have created department-specific Dashboards to make tracking department specific tasks easier for the end users. However due to limited knowledge, it's a very manual process each time a new site is added to the project timeline. I have to go into each report I've created for each department. How can I go about utilizing…
