In Excel you have the ability to automatically add trend-line. With more advanced data being added to Smartsheet from our business, we would like to have visualisation of trends, actuals and forecasts.
Hello @Thiago Castro
As of now, it appears we do not have a dedicated method for adding trend lines onto your chart. With this, you may wish to raise an Enhancement Request here. Although this feature is not yet available, we love to hear from our Customers about way we can tailor our product to different business uses, so please feel free to let use know any other features you'd like to see
Alternatively, you may wish to review this Community post where our other members were able to create a similar concept of identifying tend data: https://community.smartsheet.com/discussion/49146/help-with-trend-data
Let me know if you have any questions
I would vote for trend lines, also
A linear trend line is possible to achieve in Smartsheet, but it is not easy and it requires out of the box thinking and will take about 3 to 4 hours to set up and test.
First you will need to look up at how a linear trend line is calculated manually and understand the calculations before then recreating those in your sheet in Smartsheet.
You will need columns along these lines:
In the Calculations and Sums these numbers:
It's also helpful to set up a column needing the number of weeks or months you are projecting for.
My trend line crosses the y axis at 1474, so at week 0 it is at 1474.
For week 1 my trend line is at 1474 + (1 x 15.85)
For week 2 it is at 1474 + (2 x 15.85)
And so on....
Like I said, a linear trend line is not easy but it can be achieved. With enough time and exploration you can set multiple trend lines on the same data curve.
Have a look at this add-on: https://www.smartsheet.com/marketplace/apps/inline-sparkline-generator
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.