Can anyone help me how can I create a line chart based on below information.
Hi @Finops C'ship
Are you trying to create a line chart like this:
If so, you can create a helper column to combine start date and end date to a single cell. Then create a line chart like normal.
Yes..Can you please help me how to do it.
I did it adding a helper column with this formula:
=[Start Date]@row + " - " + [End Date]@row
Then go to dashboard and select "+widget" -> "Chart" -> "add data" -> select the sheet -> highlight the data that needed to be in the line chart -> click "ok"
Under chart type, select "line" and you should end up having the same chart as below
Here is a link for more info on charts: https://help.smartsheet.com/learning-track/smartsheet-advanced/charts-dashboards
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…
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.