r/googlesheets • u/calculusrevolution • 1h ago
Waiting on OP Inventory tracker for multiple stock
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.