Create a new view > + Grid > Add a filter of that single select column

It will not create a separate “Task” sheet. Instead a “Task View” (sort of) will be created containing supplies with “Order Soon” and “Broken” tags.

Help: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views#add_filters

I didn’t think about doing that. Works great, thank you very much!

Hi Steve…I just read you question as mine was similar but I came up with a different solution. I have a group table and a task table and I didn’t want to to add my tasks to the group table as it is quite large already (lots of logistical details in organizing hotel group events). When in my groups table the ‘status’ field gets manually changed from ‘bid’ to ‘contract’ I have a field next to it that is a ‘link to table’ to my ‘tasks’ table in which when I hit the + in that record, it takes me to a form where i can ‘add a new record’ to my tasks table. Then, in my tasks table I can have it be automated using ‘lookup’ fields to pull the details from that group (event) record in the group table.
For You: Supply table: Quantity of item field, Status field (formula that when quantity field <5 it will print “Order Soon”) Have a view “Order Soon” which is a filter for that field. When you look at that view, have a ‘tasks table’ field that is a link to the tasks table. When you hit the + in that field it will take you to the tasks table where you can ‘add a record’. In your tasks table, maybe have the primary field be an order number where you can then have ‘lookup’ fields to pull the item information from the supply table and have other fields to track order date, quantity ordered, vendor, cost, delivery date, etc. Use views, filtering and grouping to easily see the status of an order for instance.
I hope this helps! I’m having fun figuring this all out as well.