-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
3+ Levels of Filter Groups
I know I've seen this filter setup before but I cannot seem to recreate. I am trying to layer 3 or more filter groups to attain the desired logic. Is this feasible?
-
Managing Multiple Projects? Project Hub & Workspaces
Hi, I've set up a Project Hub using a template set - in a new Workspace - so that we can see all Projects in one place and, when needed, be able to see Reports for overdue tasks across all Projects rather than having to go to each individual Project for a Report. Now want to move some existing Projects into it, but I see…
-
Why is report not showing on published dashboard?
Below is a photo of two reports that are on a published dashboard. Both have the same permission settings, have been published, and are on the same dashboard. For some reason, the report on the left is not able to show while the report on the right side is able to show. What am I missing?
-
Reports - calculating the gross margin rate
I am using Reports to bring data from multiple sheets in a project, but i need to calculate the project GMR (gross margin rate), how can I do this??
-
Can't move primary column in reports when using a Group
Hi, I've built a simple report in which I don't want the primary column to be first. After arranging the columns in my desired order, if I add a Group the primary column moves to the start and cannot be moved afterwards. Does anyone have any ideas?
-
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
-
Report suddenly stopped showing any rows
I created a report that points to many different Workspaces. I used filters to control which sheet names are shown on the report. Yesterday this report was working perfectly. This morning it's not working. Any clues?
-
View All Comments in a Report
It would be nice if you were able to view all comments in a report similar to when in a sheet. You have to go row by row to see each comment individually. A tab with all comments would be helpful.
-
Reporting from worksheet with heirarchy
I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., group by one of the 'helper' rows). The % Complete and the date columns are not displaying in the 'group' heading. I would…
