-
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…
-
Disable/Enable all sheet automation with one button
I have sheet s with 10 or more flows, would be nice to enable/disable them all at once for data migration or fixes needed.
-
Ability to disable update request confirmation emails
It would be wonderful to have a way to customize the update request emails so that the end-user that's making the update does NOT have the option to get a copy of their responses/receive a confirmation email that contains the link of the sheet. Why have this feature? So that it's possible to allow teams to send external…
-
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…