-
Changing series order in stacked bar chart?
I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them. The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't…
-
I cannot change data source on chart widget
I am the owner, admin and creator of a dashboard. I have used smartsheet for many years. However, after creating a dashboard several months ago, I no longer am able to edit the dashboard. Specifically, I can no longer change the data source on any of the charts I have created. It is greyed out without any options. This is…
-
Dynamic Filter on Dashboards
I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.
-
Creating Graphs on a Dashboard
Associate Sharon Line Count 45 Total Bills 116,044.84 Average AGE 1.18 Over 10 Days 0 Jessica 7 11,295.14 1.00 0 Bryanna 42 89,121.40 17.64 10 Beth 32 70,578.30 5.16 4 NEW 1 0 0.00 0.00 0 NEW 2 0 0.00 0.00 0 TOTAL 126 287,039.68 7.67 14 Sample Data Above… I want to add multiple charts on a dashboard, one for each column…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
Organisational-Level Dashboard Placement in Multi-Tier Control Center Setup
Good afternoon, I am currently configuring Smartsheet for the organisation and have implemented a multi-tier Blueprint solution within Control Center. At a high level, the configuration includes two Blueprints: One Blueprint to provision Business Units (BUs), and A second Blueprint to provision Business Unit Projects.…
-
Number Color Conditional Formatting on Dashboards
I would like conditional formatting by color on "number" displays on dashboards.
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…