-
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…
-
Cross Reference Report - Workaround Ideas
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200. I want to get one summary field (to match on) and the sheet link from each sheet into another sheet.…
-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
-
Merged: Report Totals Printable
This discussion has been merged.