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.