-
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
-
Charts - Changing Data Range (Modify Range)
Hi, I have a Dashboard with about 12 charts from one sheet. It looks at five years of data. In 6 months I'm going to want to change that five year period. Is there any method I can employ to make that happen automatically or will I need to reselect the data on each chart for the new time period? I'll be adding the new year…
-
New Data Not Automatically Added to Charts
How do I (if possible) get my charts to automatically update with new information that's been added to the sheet? I currently have a sheet that has a scoring system based on a 0-100 percentage. When I created the chart I selected all the columns I wanted and included all 5 line entries. It charts just the way I want it to,…
-
Dashboard Charts - Using Reports
Hi The new dashboard charts are a great addition to Smartsheet. Will you be introducing a way of charting against reports as well as sheets? Or is this functionality out there and I am not aware of it? Many thanks