Hello, I use filters in all of my sheets, reports and Dynamic Views. The issue I have is not all filter options are available based on column type in Dynamic View.
When I have a text/number column that uses a 10-digit number and I create a filter in my Dynamic View, I cannot use the same filter options that I can in reports and sheets. If I try to use is equal to and type in the exact #, the filter shows nothing. I was informed by support that this will not bring in any data because it is a number. If I use contains and use the same number then I get hundreds of rows when there should only be 1 row for this primary column number.
In reports when I filter, I have more filter options such as "is one of" which would allow me to type in the number and choose that exact number from the data.
We need to be able to choose from every filter option in Dynamic View, the same as sheets and reports for the exact same column type.
