Add the ability to do an "Or" condition in Dynamic Views

Currently Dynamic Views ONLY allow for "And" conditions. Adding the "Or" Condition would save alot of extra helper columns.
Comments
-
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