-
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…
-
Highlight Changes on Dashboard
Hello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Report. Anytime there is a new entry added to the Sheet through the form, it turns the data yellow. Unfortunately, this…
-
Error With Link To Report Through Dashboard
I have an issue with a shared viewer of a dashboard where they get a blank (no content) report when they click on the link in the dashboard. As the creator of the dashboard and the report i can see the content of the report just fine when i click through to it. However they just see it as blank! They are a shared viewer to…
