-
Is there a way I can make the metric widget pull in data from the latest date on a column?
I'm using a metric widget to collect status from sheet summaries by pulling it from the first column of the sheet by using the index formula. Is there a way I can expand the formula so that it's not just pulling from the first sheet, but from the latest date that's on the Week column? I'm trying to see if there's a way I…
-
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!
-
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…
-
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?
-
Unable to Save Dashboard Widgets
Hi, I'm unable to save the dashboard after adding the widgets. I receive following error message: "Validating Request - Dashboard 203198926 plan is not active." Anyone facing the same issue? Thanks.