-
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…
-
Printing a dashboard and one of the widgets is unaligned
In the online version, everything is perfect, when I print it to PDF, the milestone chevron lanes don't line up with the "assigned to"/"health"/"status" columns. How can I fix this?
-
Help needed on a widget linked to content attached to a workspace
Hello! I am hoping someone can help me understand an error recently encountered. Our team has a dashboard that contains a widget that is linked to a PowerPoint file attached to the workspace. At creation it worked just fine, now a couple of weeks down the road, you click on the widget and you get a SmartSheet page that…
-
Combined Charts and Dashboard filter/Slicer
Hi, Anyone know if the Combined Charts and Dashboard slicer like in excel will be included on the Dashboard update on January 2021? Anyone know or has the scope of the updates? Anyone knows an alternative chart for line & bar combined chart?
-
Conditional Formatting - Report
I have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighted red. I've tried to set up a helper column but can't find a formula that refers to if the cell is a specific color. Any…
