-
Best way to calculate data across 100 sheets with same structure
Working on a project that will have 100 or so sheets with exact same structure. I need an efficient way to be able to calculate data SUM, COUNTS, AVG across 100 sheets in one metric sheet. What is the best way to accomplish this without the need to reference each individual sheet? Is there a way to run metrics on a report…
-
Portfolio Report exists & has current data but isn't showing in either Blueprint for me to edit??
We have 2 Blueprints set up in our Program & we have a Portfolio Report that currently pulls data from 3 sheets (it pulls the same 3 sheets from both Blueprints). We actually only want it to pull from 1 sheet in each Blueprint, so I went to Control Center & clicked through the pages until I got the Dynamic Report Scope…
-
Dynamic View: Option to disable Details tab
In the most of the cases user just need to see report but not details tab, this can be confusing for user
-
Moving Reports and Source Sheets to a new folder under existing Workspace
I want to create a new subfolder under my existing Workspace that already contains Source sheets for each individual with their corresponding Reports. I want to do this because we are adding new company Divisions to the same Workspace. If I do this, will each already existing person's report still have the same URL? The…
-
Tracking "Support Type" Across Events
I am attempting to create a dashboard that pulls from reports/sheets I've made that relate to event support for my organization. There are three types of support that my team offers for events. They are not mutually exclusive. The names of each support type are "Streaming," "Podium Support," and "Photography." On the form…
-
Is there a way to find out if the report is a Sheet Summary or Row Report?
I created a report few days ago and I can't remember if it was sheet summary report or row report. I don't see this listed in the properties of the file. Is there another way I can find out?
-
How to Maintain Workspace Task Bar Colors in a Report
I have multiple workspaces I am assigned work in and they have different default task bar colors set up in the workspace settings. In my personal report (not in any workspace) that combines them all into a single card view though, these colors are not maintained, instead using our system default task bar color. I can…
-
Parent Row showing on multiple rows in a report
Hi, I'm currently using a sheet with information about different projects and need to show a Parent Row on all the other different "statuses" assigned to different Subtasks of that same project, I already have a formula to show the Parent based on their children, but I would appreciate any help on this issue. Attached…
-
Can I hide the conversations and attachments menu on a view only report?
I have a report where I have hidden the attachments and comment columns and have used the iframe code to embed the view only report in an internal html document. However, people can still click on the conversations and attachments icon in the right margin and see everything. Can that be hidden? Viewer can also right click…
-
Did the report permissions get updated?
I had a report shared to other users as editor - cannot share. With this permission level, they were able to filter and sort the report but now they are not able to. Were the permission settings updated?
