-
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
-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…
-
Dynamically update dashboard after form submission
I am experimenting with the Sights feature, and attempting to have my dashboard update whenever a new web form is submitted. We have some metrics that are manually updated every week, and I'm hoping to auto-populate an overall view. However, a new form submission doesn't update any of the numbers in my Sight, they are…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
PivotTable
Hi all, How can I create a PivotTable on smartsheet? for create like this graph in attachment
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Comments in Sights
Is there a way to pull comments into a sight? I am new at this and trying to create a dashboard and was hoping to use the comments field and pull it into the dashboard. I have tried to do it straight from the metrics widget but it won't let me select any comments. I have also tried to create a report but it doesn't…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
