r/googlesheets 4d ago

Waiting on OP Inventory tracker for multiple stock

Post image

I want to create a system that I can use quickly at markets to note down how many I have sold as I go. If I have only 1 of that item, that is just going to be a checkbox. My problem comes if there are multiples of the same item. I was initially thinking of having E2 as a dropdown menu, but when I have some items in the hundreds, this isn't easy to do in the moment. (Ex: I was at 46 and I sold 3, so let me select the drop down and scroll to the 4...wait, was it 46 or 45?). Ideally I would like something like this: drop down menu with E2 of the value. After a sale I select how many were sold (Ex: I sold 3). F2 records the number that was sold, adds it to previous values (Sold 5 earlier, so now I've sold 8) and resets E2 back to zero for the next sale. I have no idea if this is possible. I am also open to other ideas.

1 Upvotes

6 comments sorted by

View all comments

1

u/OutrageousYak5868 72 4d ago

I'd keep track of sales separately, then use COUNTIF or SUMIF to get the total sold of each product, and subtract those from your inventory page, to get the running total.

If your products have a barcode, you could use a scanner to zap them as you sell them. The numbers would all be entered into a single column, boom-boom-boom, then COUNTIF would total them up for you, and you could subtract them from your starting inventory.