-
Dashboard metric widgets display is not same for data pulled from same sheet
I'm trying to figure out why the font size of the numbers are not the same for all the metrics widgets. They all pull from the same portfolio metrics sheet (shown below). Is there a way to adjust font size so On Hold and # Completed values (2, 3) are the same size as the other metrics. Appreciate your help!
-
Merged: About charts that don't have data
This discussion has been merged.
-
Reports - Percent Option with count, sum...
I would like to see an additional option for a secondary value-based column for percent of count, percent of sum on Reports. And the ability to pull that into the Dashboard in a chart.
-
Dashboard data not refreshing?
I have created a Dashboard where I’m using the chart widget, the data is being pulled from a sheet (sheet 2), were I pull data from a different sheet using formulas (sheet 1) to be used on the Dashboard. Sheet 2 is only used for calculations and counting for specific models of our department as Sheet 1 is a global sheet…
-
Text size on dashboard
I created a dashboard with the intention saving it to a PDF. However, the font in the body of the reports that I included on the dashboard is very small (I think 10 pt). Is there a way to change the font for the body of the report on the dashboard? I am able to change the font when I go to the report, but that does not…
-
Do dashboards have to be shared for WorkApp
I am trying to make a simple hub work app. The app basically just displays one of my dashboards that contains useful links and videos. If I give someone a link to the work app, does the dashboard or the sheets it contains have to be shared with everyone for them to use the work app?
-
Creating charts with multiple criteria without summary sheets and thousands of distinct formulas
I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expert. There are additional columns for each employee's name, department, and whether they are 'Active'. In order to create a…
-
Source Sheet Conditional Formatting on Dashboard Web Content Widget
Over the last few weeks, I have received notifications from users that the Conditional Formatting on a Source Sheet is not accurately reflecting on the Dashboard that our end-users are accessing. The Conditional Formatting on the Source sheet is reflecting as expected. However, the dynamic view is incorporated on our…
-
Checkbox Used as Input in Dashboard
Has anyone ever used a checkbox input from a dashboard in a formula to include/exclude certain data in a calculation for the dashboard? I currently have a dashboard where I ask the user to input a date range that would be used to parse all of the data that could be shown in a dashboard to only the data in a date range.…
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
