-
Recomendations on templates for project portfolio with dashboard
Hi, I am new to smartsheets and have been tasked to build a project portfolio (list of projects for each team with status, dates, notes) and then create a dashboard view. Can anyone recommend a template to build this quick and easy? We did have a consultant build a solution for us years ago but it did not work properly; so…
-
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…
-
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?
