-
BUG widening Dashboards
Just a FIY, When you have a dashboard with metric widgets, and you choose to widen the layout (which is permanent!) the fontsize is reduced to 10. I now have 40 metrics that I have to change back to size 12, manually each…. Not really cool! New… Old (yes, I know theyre different) Just using my NON-widened Dash from a…
-
Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
-
How to make widget that counts year in date column?
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…
-
Asset register report/dashboard showing latest child row data only
Hi there, I'm trying to build an asset register in smartsheet with parent rows for the initial addition of the asset record and then child rows to record any future tickets logged against that asset and the corresponding asset status (so the asset history can easily be tracked). The objective is to provide customers with a…
-
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.
-
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…