-
Pie Chart is Grayed out in Dashboard
I have a dashboard that was working correctly with a pie chart widget. Now the pie chart is grayed out and is no longer an option. The data does have values greater than zero so I'm not sure what the issue is. Especially since it used to work just fine. This is the formula I am using in my summary sheet to get a count.…
-
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!
Having to open each source sheet to have the conditional formatting update is not efficient. The refresh on reports and dashboards do not update the conditional formatting for each row. Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple). I log on…
-
$0 Data Point (not Graphed)
I have a range of $$ amounts (to graph). One of the points is $0.00M; however, the Graph will not "graph" that point, why? is there a way around it? I am using a report to Graph is onto a Dashboard (see below)
-
How to remove custom colors for dashboards?
After adding 20 custom colors in the range of colors for dashboards it is not possible to add more colors, but it is necessary to remove one first, to add or use another one. So far I did not find the way how to remove a previously selected custom color?
-
Make conditional formatting refresh all source pages for report and dashboard accuracy
Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away. Unless I open the source sheet, the reports in dashboards will not update. Even if I press the refresh button on the report or the dashboard, it doesn't actually…
-
How to generate a report for duration (sum hours) to generate a widget.
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number of rows with data entered. Is there a way to generate this data to extract to a widget for a dashboard?
-
How to auto-populate a dashboard when new sheets are added
I have created a workspace for my team where everyone has a sheet to enter projects and I have them all connected to a dashboard using reports and formulas. These sheets are just for small projects, but I am trying to figure out the most practical way for employees to enter their own projects and create their own sheets…
-
How can I make a graph from a report in the Portfolio level?
It appears that I can only make a graph of the whole report instead of only one column. Is this possible to do? If not, do I need to make a sheet of the data of every single column of the portfolio? For example: I need a graph of the column "Responsible area" of the portfolio, to get the data of how many projects has each…
-
How to create a chart from a report!
Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me select anything. I read that you needed to have a summary section and a group section, so I included both, but I still can't…
-
Count if formula to include multiple years
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024? Current equation:…