-
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.
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
Modifications to Internal Communications Template not showing when building reports
Good morning, I am currently working with the Internal Communications Template to create a Planner for our Learning Communications. I needed different Categories and delivery methods so I edited that information the Internal Communications Plan Sheet but when I try to use the summary reports in the template or build new…
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…