-
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…
-
Stacked Bar Chart Label Issue
Hello, I'm having issues showing data labels on a stacked bar graph. I can get the labels to appear on a regular bar graph (left) but when I stack them (right), I only get data labels for the last row. Any idea why this is happening? I thought it was only showing positive %s but noticed there would be a 10% in the middle…
-
Why is my chart blurry on my dashboard?
I recently tested the Chart widget and like the functionality, but I can't ignore the fact the text is blurry. People I have shared the dashboard with also have remarked on how blurry the text is. Is this a problem others have experienced? Is there a fix?
-
Loading dashboard in presentation mode
Hi, I have several dashboards that are all linked through clicking on different widgets. I would like them to automatically load in presentation mode, although I believe smartsheet doesn't support that feature at present. Are there any workarounds for this? Would it be possible to have say a web content widget and link to…
-
How to Get Pie Chart to Show Total Complete VS. Incomplete
I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…
-
Dashboard - add ability to get a Dynamic View directly from Widget Behavior
When adding a widget to the dashboard, if I want the Widget Behavior to open a Dynamic View, I have to go find the URL and use the "Open another site" option and drop in the URL. A better option would be to be able to use the "Open a Smartsheet item" option and be taken to the list of DVs to choose from. Thanks!
-
Possible to summarize a report based on Current User?
I'm creating a dashboard that summarizes survey data for employees. I have a report set up where they can access their information, and the report is set to filter By Current User, so they only see their own data. The report pulls from a master source sheet, which has a Contact column that maps to each employee. My…