Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Shopping list feature on Pantry Inventory

Topic Labels: Formulas
528 0
cancel
Showing results for 
Search instead for 
Did you mean: 

We have done a pantry inventory, and want to make a shopping list sheet. We would like things to auto add to the shopping list when they reach a certain level of stock.

So for instance,
If we have 12 soy milk in pantry, we want soy milk to add to the list when we reach 6, and we want to buy 12 at a time.

I am looking for a way to get a formula to do this. Is that even possible?

My column headings are
Item - Use by - Location - Stock - Minimum stock - Amount to buy

I just need the Item and amount to buy to copy to shopping list when the minimum stock is reached.

Am I dreaming?

0 Replies 0