-
Has anyone found a good way to visually display daily metrics for the month?
I work in manufacturing and I am trying to build a dashboard for our tiered meetings. I know some people might be familiar with what I am building as it is common in the industry. I have several sheets where Safety incidents and quality incidents etc. can be submitted. My management wants me to build a dashboard that will…
-
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.
-
Auto adjust Report Widget height
Currently, if the report widget height is set to display 20 rows without scrolling then when the report has only 10 rows the dashboard displays blank space for remainder of 10 rows. The white space in the dashboard, in this scenario, is often complained by our users. It will be great if Smartsheet can auto adjust the…
-
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…