I am trying to figure out a way to create an inventory table that will let me update items with specific labels. I have wines that I need to categorize into 4 different categories. For example, when I gift one, I want to both keep track that it’s gone as well as keep track of how many I gift over time. The same goes for the other 3 categories. Is there a way to do this? I’m struggling to see it in a spreadsheet as opposed to a flowchart. Thank you in advance!
