-
Summary Report for multiple fields on one sheet
I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the count is not rendering the correct results. I am using this formula for the Overall Health functions - =COUNTIF([Overall…
-
User-Created Dashboard Color Schemes
Our team would find it immensely useful to build a dashboard theme (choosing font face, font size, colors) from scratch. We strive for cohesive branding on things we build and being able to change the entire look and feel of a dashboard with just a few clicks would save us a lot of time.
-
Dashboard Widget Title Color Changes When Copied to Another Dashboard
In the past, I'm certain I've been able to copy widgets from one dashboard to another and have their title-bar formatting, particularly the background color, remain intact. Now the copies are all losing their colors and defaulting to a pale blue.
-
how to show info of "assigned to" column
Good afternoon all, New to Smartsheet but enjoying it so far. I have a question about creating a dashboard that shows each "Assigned to" person and how many tasks they have that are blocked, not started, in progress, or completed. If there are any recommended how-to videos on dashboards anyone would recommend, I'd be…
-
Copying Dashboards - Formatting Issue
Hello, I used to be able to copy Dashboards directly from a dashboard into a separate dashboard page with a simple copy and paste command and formatting was unchanged. Now when I copy and paste it over, the existing formatting (the colors of the series and legend, specifically) are all changed back to the default settings.…
-
Stacked chart in dashboard
My Report is grouped by 2 fields - first month and 2nd type of deployment (reg/hotfix). i want the chart to present the total deployments monthly and the stacked chart should show how many are reg and how many hotfixes month wise. the dashboard is showing monthly data but not further showing the type of deployment. please…
-
Merged: Dashboard Widget and/or Report for Attachments
This discussion has been merged.
-
Dynamic Dashboard Widget Size
Is it possible to have a Dashboard Widget expand or contract based on the number of rows in a report? I have a number of dashboards that are all the same, but the information varies greatly from report to report. I would like to consolidate white space as much as possible for the ones that only have a little information or…
-
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…