-
Stacked Column Legend Shows Categories with no Values in Chart
Hello, My dashboard has a Stacked Column chart. There are many data sets it's pulling from, but not all have values (see picture; of the 28 data sets in the legend, probably only 10 of them are actually on the graph). Is there a way to get the legend to only show data sets with values reported in the graph? Eventually this…
-
Merged: Adaptive Height Report Widgets in Dashboards
This discussion has been merged.
-
Filtering/Illustrating Data From Date Columns on Dashboard
I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each item filtered by year, and then each item has its own specific date on the sheet. What formula can I use to do this on a…
-
Best way to compile rolling metrics for Dashboard Update
I'm working to build a dashboard that presents monthly metrics. I want the dashboard to automatically update to display the last 12 months' metrics. I have a metrics spreadsheet that calculates all the information for each month. I'm wondering if the best way to achieve this is to create a new smartsheet with a formula to…
-
Outside User is receiving error symbol when viewing a published dashboard
Hello, I created a dashboard with a dynamic view that is shared to an outside source based on domain. I then published the dashboard and sent the link to the outside user. The user shared that he is receiving an error symbol within the dynamic view and is unable to view any of the information. Please let me know if you…
-
Dashboard Issues & Privacy
I have a master data sheet with data on it for 5 different clients. I've then created a series of reports that filter information for each client so they can view their own data without seeing everyone else's data. But I can't give them access to a report without giving them access to the source sheet. So I created a…
-
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
-
Line Charts in Dashboards - Need two lines on one chart
Hi there! I'm building a dashboard from data I'm collecting from and individual and their respective manager. The individual rates themselves on a metric each week. The manager rates the individual on the same metric each week. I convert the ratings to numbers and put them in a row their own row - one for the individual…
-
Smartsheet Formula of The Week!
Hey Smartsheet Community! We're excited to introduce our DigitalRadius' Formula of the Week Email! Each week, we’ll share a practical Smartsheet formula to help streamline workflows and solve real-world challenges—all for free! This week’s formula: Flag duplicate values in a column to clean up your data and avoid errors.…
-
Web Content Widget not working
Hello, I'm trying to add a view-only version of one of my sheets in the dashboard. Using the Product Development Roadmap Dashboard template from Smartsheet itself, I see that I need to use something called 'Web Content Widget'. I don't see that option when I open the Add Widget pane: So, I tried to go inside the widget…