I have a stock report created daily by EZOfficeInventory that shows current stock quantities in one column, and the low stock threshold in another. If needed, I can have a new Google Sheet, Google Doc or Airtable records created.
Is there a way to automate the removal of the rows where current stock is greater than or equal to it’s low stock threshold?
The goal is to send our shop manager a list of the items we are running low on to make sure that we do not run out of stock, particularly in the high volume items.