-
Report Filters Not Responsive
I've created a helper column in my sheet for parent/child relationships, which assigns it a number based on this formula: =COUNT(ANCESTORS([SOW Item or Task]@row)) + IF(COUNT(CHILDREN([SOW Item or Task]@row)) > 0, "+", "") In my report, I've created a filter to allow for all numbers except 1+: However, the report is not…
-
Rolling up counts from several sheets to a dashboard
I have 6 projects. Each has a risk register on a separate sheet Each risk has one of 5 possible statuses each of which has a color, (Blue, red, green…). Each risk also has a Probability/Impact score, grouped by 5s, 1-25 I have created 10 sheet summary fields on each sheet to count these. I have created a sheet summary…
-
Pie Chart from Two Sheets
Hello I have two sheets that are in effect the same - same column headers etc, but different source data feeding in. I have a sheet summary on each. For example, if column 1 has a yes/no option, I do the following on each sheet: =COUNTIF([1. Internal Process]:[1. Internal Process], "yes") I now need to be able to combine…
-
Ability to add Sheet Summary Reports to Dynamic Scoping on Control Center
This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scoping for those type of reports, it weakens the case for Control Center. It's either we bulk sheets up with columns to fully…
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
Sharing reports with free users
Hi - I have created a report and shared it with an external free user, however, he is unable to see anything on the report. I also tried publishing the report and placing it as a widget in a dashboard with no luck. Is there anyone that has done this and can let me know how to provide them the info? I also wanted them to be…
-
Linking Formulas to Reports
I am currently working on pulling engagements/deliverables and other important information from all my projects into one consolidated program level dashboard. An example of what I came across, I can create a report where I pull all the tasks at risk across my project schedules and it is very easy to add a schedule to the…
-
!! Help share content!!
Guys! The smartest people I know! Does anyone have recommendations or best practices to do or do not do related to sharing materials with customers. We currently share a Workapp with implementation customers. And I do not have a good resolutions for sharing files, videos, user guides attachments either via upload or link…
-
Parent rows with children in a report to look like a filtered sheet
Hello, I'm looking to have a filtered sheet like experience (picture A below) in a report with a parent and child look, but everything I have tried doesn't get me there. The goal is to have the parent info and be able to expand or collapse the children so they aren't lost at the end of the report when you pull the…
-
How can I create a new sheet or report that pulls in SUM from an existing report?
I currently have a ledger report (Report A) that pulls in budget data from two sheets. In Report A, the report groups the line items by brand and provides a SUM of budget per brand. I'm needing to create a new report (Report B) which can technically be a Sheet or a Report - but what I'm needing, is to pull in the SUM by…