-
Select Specific Rows in a Report to create a Chart
Creating a chart in a dashboard: Sourcing data from a Grid sheet you can select, i.e. Row 4, 5, 6 BUT if you are sourcing from a Report, then you can NOT select ONLY rows 4, 5, 6 for example. Smartsheet automatically selects ALL rows in the Report to create the Chart. The report I have, contains around 50 rows, which makes…
-
How to overcome lack of customization of dashboard chart widgets?
How can I overcome the inability of Smartsheets to allow more customization of the chart widgets? In particular, I cannot change the size, position and colour of the data labels. Also I cannot select "No Fill" for the data series fill colours.
-
Adding Vimeo Showcase to an existing Dashboard (via the web content widget)...
I can add a Vimeo video successfully to an existing Smartsheet dashboard, however for some reason I cannot link a Vimeo Showcase in the same way? I get the following error message Invalid URL or embed code. URLs without https are also prevented. Select the link above to see what content is supported (which takes me here…
-
Dashboard with multiple screens
Is there a way I can force publish linked to open in the same window, rather than opening a new tab every time?
-
Average on charts in Dashboards
Is there a way to get an average line on the charts in a Dashboard?
-
Automated Dashboard Metric Updates
Hello! I have a dashboard for one of my projects where I use a metric widget to share updates on each objective. I have an underlying sheet that sends out update requests every two weeks to the leaders of each objective. I have an automation within the sheet that archives old updates to an Archive sheet. I want the latest…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
Date line graph--is this possible?
Hello, I'm trying to figure out how to create something like the image attached. Each point is a project and the dates correspond to the approval of each project. Each dot would have a project name label on it (removed here for privacy). They are horizontally divided by market (each color is a market and label also removed…
-
Capture historical data for KPI dashboard
Having real-time data available for our dashboards and reports has improved our management capabilities. I want to be able to share how we have been doing over time, as well. I want to capture and report KPIs over time. I have a report that can capture the information I need but have been trying to figure out how to…
-
Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard
I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of…