-
Graph has no Continuous Trend Line
Smartsheet has great visual graphs, one problem however is it does not have continuous trendlines (like Excel - but this isn't perfect either). So If I have 12 months and say 4 data points, I end up with a part-line & scatter plot; instead of the line graph I selected (does not show the full line or full trend). Ideally I…
-
How do we make Graphs look the same on desktop and mobile dashboard
We have a dashboard that has 3 graphs in it, based on reports. On the desktop version Y axis starts at 0 and has specific colours for the different lines. On the mobile version the y axis starts at -2 and has different colours for the lines. This is on all 3 graphs. How do we make them be the same graphs?
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have…
-
Creating a graph from 3 variables
Hello, I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example: I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new…
-
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…
-
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…
-
Showing Cumulative Work Completed Over Time
I have projects that are being completed and assigned a completed date. I have a column named "Levels" to filter to the data I want to track. I would like a graph that charts the total number of "Level 2" completions over time. The way I picture this is a bar chart. The bar has two sections: 1. Everything accumulated…
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…