Hi Abigail,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am not sure i fully understood exactly what you need to achieve.

1. If you just need to hide any rows that have value in Quantity less than 1,  with a Google Sheet Table, one way is with Conditional Formatting.

Like this, here is my Test Table :

A Condition like : Check if any cell of this Column is less than 1 ,  in that case, set the row CSS class to "hide".

2. Or if you don't wish with the Conditional, but to allow users to change the Filter/clear it;

Then you can set a Number Range Filter, and set the "from" value to be predefined as "1".

3. Another way can be via URL pre-filtering.

Please check the Documentation on the hyperlink with our example.

With a Number Range, you need to use the " |  " stick symbol for the URL predefined filter parameter on this Column in order to get only the "from" value on the number range.

On my example the full URL is :

http://localhost/current/pre-filter-above-zero/?wdt_column_filter[2]=1|

Since the URL pre-filtering uses a zero based index for column number, my "Quantity" Field is indexed as number 2, so i add this as parameter :

?wdt_column_filter[2]=1|

-

I hope that one of these methods can achieve your goal, but let me know if i misunderstood it.

Thanks.