I have created a scatter table that has the readings from the days from start date.
I would like this as a smooth line table but the horizontal values should be the actual date.
Is this possible?
You would make sure to include the date column in your data selection for the chart and then select the option to use the first column as data labels.
I tried that but it doesn't spread out the horizontal graph properly. It just bunches it all up
I'm not sure I follow. Do you mean that you would want larger gaps between dates that are further apart and smaller gaps between dates that are closer together?
Yes larger gaps when dates are further apart, smaller gaps when there is only 3 days between readings. This would make the gradient of the lines more like real time.
If I had done readings at a weekly frequency this wouldnt be a problem
If you set up a second sheet and pre-fill a bunch of dates with each row being the next day, you can then use a formula with a cross sheet reference such as an INDEX/MATCH to pull the data for the correct dates.
Then in another column you would use a formula to say that if the second column is not blank, pull the date.
Move this last column over to the left and the data column immediately to the right.
That last column built will be the data labels for your chart.
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.