How can I use smartsheet to display monthly changes with a barchart. I want to be able to add the data to a sheet so that it populates the bar chart monthly in a dashboard while showing the data of previous months to compare?
There are a number of ways to do this. How exactly are you gathering your data for the "current month"?
I just want to be able to input the data on the smartsheet so that it will be able to update a dashboard
In that case you could have two rows for your chart to look at. One for the current month and one for the previous. Each month you would copy/paste the date from current month to previous month and then enter the data for the new current month.
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.