-
Can I use a workflow to add a Funtion into a column based on other columns data?
This idea is to pull text from one column to another; examplet Below Primary Column: Country Names Child Primary Column: Secondary Project Workflow 1: When a new row is added, place formula to pull text from Child row into new column Workflow 2: When new column is added, place formula to pull data from Parent row into new…
-
Merged: Filters on Reports
This discussion has been merged.
-
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…