-
Sharing reports with data without even view access to the source sheet
Today in order to share data in Reports we would need to provide view/edit access to the underneath sheet / source sheet. That's not exactly what many of users expect from Reports. This is a pretty typical task to have a data frame (source sheet) and using Reports provide access to certain portions of data to different…
-
"Edit" Option in Publish Reports
As a user i want to Publish a Report and have also the option "Edit" in the sharing properties , (not only "View " )this because i can embed it in a Dashboard and modify it from there
-
Sort for Only You vs. Sort for All Viewers
It would be super helpful to allow users to sort a sheet without applying the sort to all individuals actively viewing the sheet. We have many shared sheets that are worked on in parallel, and when one person sorts it affects the other person's work.
-
Quick filter on columns (like other spreadsheets do)
I'd like to be able to just do a quick filter on a column or more than one column without having to create a whole filter on it. For example, I'd like a quick dropdown on "Responsible" where I could check of one or a few names and it'll just show me those. Then I could do a quick filter on "Status" column and select only…
-
Add new filters in Report
Hello, I would love to have in my reports the possibility to filter on "This year", "Next year", and "Last year", according to a date type column. Today we can just define an date interval for example "after 01/01/2023", "before "31/12/2023", and it has to be updated every year. I hope some of you will vote this…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…
-
Option to Include Children on Filter
Similar to the Include Parent Rows checkbox, an Include Child rows checkbox would be useful.
-
Automatically Delete Attachments when a condition is met
To save on storage space, I would like to automatically delete attachments to a row when a condition is met, as I would no longer need to reference those. Thanks!
-
Enable Column Formulas to Be More Flexible
Hello SS Community, I was fortunate to find a fantastic trick proposed by Paul Newcome in 2021 to index the occurrence of a value in a given column. It was exactly what I was looking for. The only drawback is that there are limitations to column formulas (see screen clipping). In my solution I am using Absolute references…
-
Ability to apply a default formula to a column, but allow manual overrides on individual cells.
We need the ability to apply a default formula to a column (such as =[Request Date]@row + 7), but allow users to override the result on a row-by-row basis when needed. Currently, if we use a Column Formula, it locks the entire column and users can't make exceptions or input a different value in one row. If we remove the…