-5

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.

Improve this question
  • This is really broad, and really rather beyond the ken of this site. There are so many things you might do, or ways to do things, that there's no practical way to answer your question. Stack Exchange sites do better with questions about concrete, relatively small, issues that have direct, objectively correct answers. A question about why a particular function isn't giving the value you expect, would be one example. Remember, too, that we like questions and answers that will be useful to many more people than just the Asker. – ale Aug 17 '16 at 13:24
  • @AlE. Thank you for the feedback, and I appreciate it. I'm new to the site and must have misunderstood the types of questions I should ask. – CaptainBastille Aug 17 '16 at 14:27
  • @AlE. Would it be a better question if I made it more clear that the only function I want help with is with creating a time stamp column that updates for each row when a value in said row is changed? – CaptainBastille Aug 17 '16 at 14:28
  • These sites are a bit different. The tour should be helpful. – ale Aug 17 '16 at 14:29
  • That's a quite focused question that should be just fine, but I'm pretty sure it's also already been asked. Let me see if I can find the duplicate. – ale Aug 17 '16 at 14:29
0

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): enter image description here

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.

enter image description here

Improve this answer
  • Thank you! This looks like it might work too! I'll let you know if it works! – CaptainBastille Aug 17 '16 at 17:26
  • Your Airtable idea is the one that worked but I can't vote on the comment so I'm gonna mark this as the best answer! Hopefully that at least gives you credit! Thanks again, you totally saved the day! – CaptainBastille Aug 20 '16 at 5:18

Not the answer you're looking for? Browse other questions tagged or ask your own question.