-
How to automatically have a report update when a new sheet is created in a workspace
Hello! I am trying to create an ongoing report/ chart with a workspace. So that anytime a new sheet is added to the workspace, it automatically updates the report, therefore updating the chart on the dashboard. I thought I had it figured out, but then one of our employees added a sheet to her workspace (outside of any…
-
Weekly rotating roles formulas
Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Weekend On-Call 2 (Sat-Sun) I have a sheet with the list of [Name]s and a [Resource #] column to use for creating the rotation…
-
Merged: Visible Column Description in Report
This discussion has been merged.
-
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.