-
Extract data from a Program level report
I have a report with the Report Scope set to "Programs". What is he best way to extract the reported data into a grid and keep the grid current. The report refers to 20+ underlying sheets in the program. Would it be possible to do this for a report that has multiple sheets in the scope - that is it is not a Programs report?
-
Can columns with different names be merged in a report?
I am trying to create a report to consolidate task lists that are managed by other people. One person may have used "start" and another used "start date" for the same purposed. Is there a way to merge those into a single column in a report, short of forcing everyone to use the same column names? I do have the option of…
-
Data one one line
Hi, I have the data across multiple columns how do I have it all on the main parent level. I would like to build a report that includes it all but having issues since the data is in a different row. Then I need to be a formula so it auto calculates going forward since the data will be dynamic
-
Dashboard text fields
Hi, I have a sheet and the level 1 parent is serial number then under it is a level 2 parent with specs such as year: Make: Model: Can I make a dashboard that reports all the text that is after the year, make, model. Etc. So if I go to a dashboard I can see how many are a year 2020. The 2020 is entered by an employee.…
-
Reports and Sheets limited to printing 100 images only
One of the team has asked about printing to PDF a Sheet that contains more than 100 images embedded in the Sheet (not attachments). When attempting to print, only the first 100 lines of data is displayed. Has anyone worked out how to overcome this? (I don't want to have to separate PDF's.)
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
Wrap Text Sheet Names in Reports
Be able to choose whether wrap text is applied to sheet names when included in a report.
-
Calendar App Data Grouping Order
Calendar App gurus, please help. I've got a Project Plan sheet that I've got five groups or buckets. I created a Report that only shows the top-level records/rows (so five rows). I have created a Calendar App from that report that is sorted the way I want it to display, but in the Calendar App, it has things out of…
-
Dynamic Report Filter
Is it possible to have a report base a filter on a cell value?
-
Why did I get an error message on my dashboard that says, Source report unavailable
Hi, I got an error message on a dashboard I created. It says, Source report unavailable. Please have a dashboard Admin select a new data source. I'm the owner of the dashboard. It was working fine until a month later.