-
Merged: Dashboard Widget and/or Report for Attachments
This discussion has been merged.
-
How do I have a count of items on a report on my dashboard without a metrics sheet?
I have a dashboard that displays a few reports on it, with the list of items in those reports. At the top of my dashboard, I would like to simply have a count of how many items are in the reports listed below it. I currently have separate metrics sheet that calculates this, but I find that the count of items the metrics…
-
How to have multiple sheets show active items from a master sheet containing statuses?
I have a master sheet and want to feed multiple other sheets information from it. Master spreadsheet: is an employee roster, listing all employees and their status (active, inactive) Sheet 1: has a list of required training and training expiration dates Sheet 2: has a list of company assets assigned to each employee I want…
-
Merged: Collapsible Dashboard Capability
This discussion has been merged.
-
Realtime Metrics constrained by static columns and dashboard limitations
Smartsheet Community I have a dashboard for client that shows various financial and reporting KPIs/metrics for their business. One of the widgets they have requested is a 12-Month moving sales table that shows current month + last eleven months. I have figured out how to create the table in a sheet using various functions…
-
Printing from dashboard does not fit to page
Hi I have created a dashboard but when I go to generate the pdf, it only fills 70% (ish) of the width of the page, adjusting the % in the print dialogue settings makes not difference unless you are shrinking it, and changing the page from A4 portrait to A3 portrait gives the same result. Any ideas on a fix? Thanks Lee
-
Standard Size Dashboard from Expanded Dashboard
I have a Dashboard that is in Expanded Size, but am making a similar Dashboard that I need in Standard Size. Without having to recreate all of the widgets and start from scratch, is there a way to convert an Expanded Dashboard back to Standard Size?
-
Dashboard overlay
It would be nice to have a graphic in dashboard that you can over lay metrics. Example, a map and then have key points were you can overlay the metrics on each state. This would allow the dashboards to be more visually appealing. I did create a map in Smartsheet but each State is a metric widget. Its not that graphically…
-
Dynamic View and "Group By"
Hi there I have a large sheet that i have used the "group By" function to collate by a particular column fields - when i add a dynamic view to make this sheet editable on a Dashboard it loses the groups and reverts to an ungrouped Sheet view - any thoughts ? Help appreciated :-) Trying to reduce clicks one day at a time…
-
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…