-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
Automatically filter values that are '0' in reports
Hi, I have set up a report that reflects status updates. There are a lot of values here that are 0. When I project this, the chart is cluttered with legends that don't have any values . Is there a way to automatically filter out the any cells that have zero in them and only project the cells that have values in them…
-
Column Descriptions in Reports
Column descriptions from sheets should also be visible on all reports using that column. It is important information for anyone using a report, just as it is for those viewing a sheet. Thank you
-
Change Sheet Summary Field Name from Sheet Summary Report
We are working on a client project. We have 15-20 summary fields and we want to create 5-6 more. The problem is if we add exact names of 5-6 fields, it will take hours to finish it. What we want is to name those fields as 1,2,3,4,5,6 and save it quickly. After this activity, we can. create a sheet summary report and change…
-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Automate Group membership management
Idea is to automate group management based on some users' information like: email domain Licensed/unlicensed Active/Inactive User description or attribute that can be used to enter text to be used as filter And also schedule report to send group membership to group owner.
-
Full Screen View Default for Published Report Widgets
I would like to have an option for reports that when it is published, I can default it to full screen view. Currently, you would have to manually click the expand button to remove the top blue bar. "Normal" View: The below icon will expand the report to full screen view. I want this to always display the widget in full…
-
Please create a warning/error message for Sharing discrepancies
If a user is assigned sharing to a report (e.g. editor, cannot share) but does not have equivalent or greater sharing privileges in the base sheet (e.g. they are only a viewer) the user will have issues making changes in the report as expected… The owner/admin then has to remember to look for this underlying…
-
Email Report Summary of Tasks at risk - ONLY IF 1 or more tasks are "At Risk"
Hi, I have a colum "at risk" in my sheet, id like to set up a report that sends to summarise all items at risk, i have the report set up this is really simple and no issue. How do i go about restricting the report to only send if 1 or more items meet the criteria, rather than sending a daily blank report and me having to…
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
