-
Cannot Copy Chart Formats with New Data
Hello, When I copy a graph on the dashboard it keeps the same formats (color scheme, grid lines, etc.), however when I change the data I want to look at it completely reverts back to defaults even if the data is the same # of cells and the same type of cells. Is there any way to keep the same formats but change the data…
-
How to create a non-updating widget with key background/info
What kind of widget do I need to create to present basic descriptive text (background information) about a project? I’d like to pull the basic data from a sheet that is seldom updated. The widget would be in a report about a real estate transaction. Background data I’d like to add in widget from the non-updating sheet…
-
Pie Charts and 2 rows of data - Possible Bug w/workarond
Just submitted this to Smartsheet, thought I would share with the community to see if it was indeed a bug, or if anyone else has experienced the same? Bug: I have a report with two lines of data showing... When reflecting that data on a dashboard, I am unable to select a pie chart when there are only two lines of data from…
-
Linking to a Smartsheet functions
I've seen posts that contain links that create an action, such as "click here and a copy of that sheet will appear in your instance of Smartsheet" I cant find the OP, and cant recall if she was staff perhaps, but the link worked. Is it possible then for me to create links to actions, for instance a link from that would…
-
Adding Data Rows for Dashboard charts requires reformatting?
I created a sheet to put my data in and created a bunch of charts tied to it. For example, each row represents that week's data. BUT . . . as I add new rows of data for new weeks, I'm finding I have to re-establish the data field for the charts and when I do, I lose all of the formatting for the chart and have to reset all…
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
Dashboard Error
Hi guys, Wondering if anyone can help me out with a Dashboard error i am seeing? I have attached the screenshots relevant. * The error is presenting on a Dashboard which looks up to a Summary Worksheet, which in turn references the core detailed data. * The Chart Type i have selected by default is a Pie Chart (shouldn't…
-
Enhancement request for SIGHTS: Metric-/SheetData-Widget based on reports
I'm missing the ability to insert data into Sights based on specific fields or ranges of a report. Currently one can "only" insert a report as a whole. If you want to show certain fields or ranges like with the metric widget or sheet data widget it is only possible to pick them from sheets, not from reports. Why is that?…
-
Enhancement Request: Sheet/Workspace Level References in Formulas
I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will. This would…
-
email data from smartsheet nice visuals
Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible