I am new to creating dashboards in smart sheets. I am having an issue with the chart widget. I am trying to do a line chart and all I get is dots. What am I doing wrong?
To get additional lines you are going to need to build out the table. Which way you go is going to depend on exactly how you currently have your data structured and widget set up.
I imagine you have something like the months in one column and the counts in another column sort of like this:
so on and so forth.
To include another line, you would have those counts in another column
Then include all columns in the chart.
Your horizontal axis needs more data points. Are you planning on plotting some kind of trend, or are you just showing those three pieces? If you are just showing those three pieces then you may want to consider a column/stacked column or bar/stacked bar graph type instead.
Paul I am trying to show a projection for the whole year. So those numbers would be the numbers we want to achieve by year end 2022.
Are you wanting to show actual in comparison to the projected, or are they the only data points you want displayed? Are you wanting monthly breakdowns growing cumulatively as the year progresses? If you are wanting monthly points, then you would need to enter each month onto its own row to have those points plotted.
Hi Paul thank you for your help. I broke down the numbers I had into months and those are now on there and it looks good. Is there a way to get more than one line on the graph. I am now getting something that looks like this but I need three different lines on it to show the different totals.
That is great thank you for your help!
Happy to help. 👍️
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Hi - We number tasks in our Smartsheet grid using the format XXX.X. When we sort in descending order, the numbers are not in order. For example 200.0 appears below 001.0. Since it is in descending order 200.0 should appear before 001.0. We also want to start using four digits before the decimal point and want to know if…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.