-
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…
-
Change row report to sheet summary report?
Hello, is it possible to change a row report to a sheet summary report? So that i can keep the same link because i have it linked to on several other dashboards. I'd update the criteria too. Thanks!
-
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?
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
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…
-
How to automatically have a report update when a new sheet is created in a workspace
Hello! I am trying to create an ongoing report/ chart with a workspace. So that anytime a new sheet is added to the workspace, it automatically updates the report, therefore updating the chart on the dashboard. I thought I had it figured out, but then one of our employees added a sheet to her workspace (outside of any…
-
Wrapping cell text in reports
I really wish that I could wrap text in a report without having to do it in the sheet it's pulling from. I have a sheet that has multiple columns that contain a lot of text that doesn't need to be seen every time someone looks at the sheet. But it would be great to have a report that shows the wrap text version so that…
-
Send report as an attachment - hidden columns
Hi, If a report is set to be sent as an attachment in an Excel file (File > Send as Attachment....), will it include the hidden columns? Regards, Joaquin
