-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Improve Functionality of Report Filters
I'd like to see report filters improve. I've included a post from another user that was submitted a few years ago. Ideally, the report filter would allow for @row references. The use case that triggered this need for my company was the "between" function for a date field. I want to see any projects that are between two…
-
Any ideas on an easy way to capture data on a rolling monthly basis and show on a dashboard
We are capturing different types of statistics for multiple different subject areas every month and need to: a) easily get people to update the data b) easily show it on a Dashboard I've tried multiple different ways of sheet design but I keep coming up again blocks - ie either data can't be shown in a graph or the…
-
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…
-
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…
-
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…