-
Planned vs Actual Charts
Hi everyone! Looking for suggestions on how to show planned vs actual in chart format. In Excel, we can have a line that shows numbers or percentages for planned and another for actual and then put it into a chart which shows the planned line and then actuals in a bar graph. I've provided an example below. Looking to do…
-
Excluding All Categories with 0s from Dashboard Graph
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
-
How can I fix my graph so it doesn't say +4 More?
I need all of the categories in the graph to show ON the graph. No matter how big or small I make the graph, it keeps showing +4 more or, even worse if I put it in presentation mode it says +6 more! I need to go back to having everything. This graph is pointless the way it is.
-
Stacked bar chart total values displayed above bars
I have several stacked bar charts due to lack of area graphs. These charts show data over time grouped by a category. The problem is that the user ends up 'approximating' the total of each stacked bar without having an actual total value displayed. Could you please add the ability to add a 'sum total amount' above each…
-
Stacked bar on dashboard - widget behaviour take you to the sheet with the filter by person
The idea is that by clicking on the contact person listed in each part of the column, the widget behaviour is that it takes you to the sheet with filter to that person and status. I imagine this is possible since the information is already extracted to build the graph, so these actions can be identified.
-
Date Display in Charts After Recent Update
After the most recent Smartsheet dashboard update, there is an issue with how dates are displayed on the x-axis of existing charts. Previously, my charts showed the full range of relevant dates, which was essential for accurately communicating trends and timelines. However, post-update, the x-axis now only displays…
-
Need help creating graph - reports late
I need to create a graph, for two different people, tracking to see if reports are done on time or not. I need to use the assigned to column and then the days late column. Negative were done early, 0 were done on time (Day Of), and then positive numbers will be late. Each graph would be just the one person, and then %…
-
Double Access Graph and using dates
it would be great if double access graphs would be available in Smartsheet like excel Also, can something be done with the dates, so you don't need to do a formula on your dates to be able to put them in order in graph. it's really annoying to have a 1 in front of your months to be able to get them to display…
-
Modifying the vertical axis on graph
I have created a stacked bar graph on a dashboard from a metrics sheet, for some reason the vertical axis is showing the values as 0, 1, 1, 2. I can't work out how to change this, any ideas?
-
Adding graph and counts to a dashboard
Hello there! I am looking to add to meeting dashboard. I have a sheet tracking our quarterly goals (seen below) and a dashboard for our weekly team meeting (also seen below) - what I would like to do is add a count of goal health per person- X amount of goals in the green, x in red, x in blue, etc. The summary of goals I…
-
Task totals across multiple plans & within a set timeframe
Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I want to look at a timeframe scale of the last 3 months and the next 6 months. The four departments are: Editorial, Design,…
-
Graph Axis Autoscale Double Counting on X-Axis
Hello, I have a graph showing the number of projects under certain teams/criteria. At the moment there is only 1-2 projects for each criteria. When using a bar chart, I am seeing the scale double count as per below. Has anyone seen this before and know the root cause? Grateful for any shared experience, Protonsponge
-
Logarithmic scale for chart widgets
When using Dashboard Chart Widgets, the charts look great if the data is within similar parameters for each row/column. However, if you have one row that has outlier data (see picture), then all the other rows are hard to visually see what's going on. The solution would be to allow for charts to have a logarithmic scale to…
-
Graph Axis
Hi, is there a way to alter the text in the category labels on a bar graph? I didn't think so but wanted to double check because I'm not sure why one graph is slanted text and the other is straight and overlapping.
-
Is there a way to create a dashboard that will update weekly?
Right now I am sending out a weekly report, but am using excel and pivot tables. Some of the info on the report is YTD which is easy to set up, but other tables are only from the past week. Is there a way to set up graphs/tables that would update M-F weekly on their own? I don't want to pull from the last 7 days as that…
-
Milestone Trend Analysis (MTA) Chart creation on dashboard
Hello, I'm adapt/add a Milestone Trend Analysis (MTA Chart) on Smartsheet. Is there a way to reflect his on a dashboard. Here is a copy of what I would like reflected on our dashboards. Not my data but I saw this for usage with MSProject. I'm looking to have sheets with data and project/display this data on the dashboard…
-
Did stacked charts change?
Good afternoon, someone from my team has pointed out that they can no longer see both values on a chart just the cost is shown and the formatting is different. Did Smartsheet change the way the stacked charts are shown? This first screenshot is from September 2024 where it shows both the quantity and cost at the ends of…
-
Customizable Axis Values in Smartsheet Dashboard Graphs
It would be useful to have the ability to customize the horizontal and/or vertical axis values for graphs so that series of graphs can present data in line with each other. In our instance, we have created a dashboard containing all the members of our team and their projects. We have separate stacked bar graphs for each…
-
How to actually USE the summary info from a report?
I have two reports both bringing in information from the same sheet. One is grouped first by country, then by month. The other is grouped just by month. For each of these groupings, I have it summarizing totals and maximums for each column. This is brilliant, this is exactly the information that I need. But now I need to…
-
How to visualize program status
I have recently come on to a large program with many different projects all at various stages. My immediate goal is to consolidate this information and try to visualize it on a dashboard so that we can start to understand where each project is. A general overview of our project life cycle: Ideation (V0) —> R&D Planning…