-
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…
-
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
-
Reports: Group By Label Display Issue
If I make my primary column an Employee ID and want to make that column smaller, it cuts off the name/label of the column I am grouping by in the report. Is this a product feature upgrade that needs to happen or a glitch? It is super inconvenient and makes my reports look very ugly when there is a ton of space left after a…
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
How can I click into a report in a dashboard and have it bring me to the sheet?
Is there a way to be able to click into a row in a report on a dashboard and it brings you back to that specific sheet? Not to the report, but the sheet that the row was created from? So far I can only find out how to go back to the report. Is there even a way to do that?
-
Report does not display new sheet names
New user here. I have looked through the help but cannot find my specific question and hope to find help here. I ran a report summarizing specific content from various sheets and filtered the results based on which sheets and content to display. I updated all underlying files to sort them in a way I want them which also…
-
Show parent OR task at same level as parent in report
My past due report was showing the naked tasks without context, so I wanted to add the parent. I added a helper column with '=(PARENT(Tasks@row)) and grouped the report by that column. That works for some of the items, however here's the issue, some level 3 items have sub-tasks and others don't, so some tasks are at level…
-
Why does a report show up blank on mobile device
Why does a report when accessed via a mobile device like the iphone show up blank unless the viewer selects the button #2 at the top. This can be very confusing for people not familiar with SS. Any way to force the button #2 to show by default? I assume if I embed on on a dashboard it would correct this but why do this…
-
Edit Reports Sent as an Attachment
Not exactly a new idea... But, something that would make my life easier. I have reports set up to send as an attachment to our client weekly. The distribution list occasionally changes. When this happens, I have to delete the schedule and start from scratch. The only thing I can edit is the schedule of when it is sent and…