Inventory Using Google Sheets

Question

I'm running Google sheets on a Windows laptop and using Google Chrome as my browser. I work in a clothing store and would like to make an inventory list that my coworkers can access and update (maybe using Google forms?). I would like to organize it with counts for each type of clothing we sell and would like for it to show the date and time that each section was last updated. For example, division 50 is pants and shorts and whenever someone posts a new count from that division I would like the other column to show who it was and when. If anyone knows how to do this I would really appreciate some help and advice.

Also, I would like my coworkers to be able to access and update the inventory list from their smartphones.

Answer 1

I made a Google Sheet that looks at latest fuel entry for vehicles and another spreadsheet takes the latest entry per vehicle, and shows the number. You could likely use it for your Inventory since the concept is the same. Your folks enter via Google Forms and latest entry per item is what shows up on a different sheet. Readings & Summary sheet and the Actual Form

Enter the values you want for Inventory updates here (in my example odometer reading):

Then this sheets shows the latest Max odometer reading by vehicle. For you, you'd want max transaction date for an item and get the count and person who entered that count.