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