Currently Dynamic Views ONLY allow for "And" conditions. Adding the "Or" Condition would save alot of extra helper columns.
Sign in to see the current vote count, add your own vote, or leave a comment.
This is accurate to a lot of issues on Dynamic views, if we have a Or option we could utilize to create only one filter.
I would definitely find this helpful but would also like to be able to search in addition to building filters. (Find "abc" anywhere on the view not just in a particular column.)
Also important to be able to Filter by a Date field.
For example: Show me all my rows of items that are past due. Things due in a week. Things due in the future. These are filters we can do with Sheets and Reports. We should have the same Filtering capabilities in a Dynamic View.
Agree on all above - would be very helpful to have OR option to allow a lot more flexibility in filters in Dynamic View
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
The current logic behind the "Last Activity" column in the True-Up is not useful for performing True-Up nor ongoing reviews of licensed seats. I need to know when someone last made a modification to any sheet regardless of the level assigned to the modified sheet. In my case I have a project manager who is an owner on…