I would like to use Google sheets to create a Job schedule and tracker. I need to be able to log start time, end time, log quantity good, quantity bad, quantity in process, quantity incomplete. I need to be able to clock in and out a job. Please see excel attached as example of what i have. I need this to be as automated as possible. If QR codes can be implemented great. I also need graphs that collects data from this information
THIS HAS TO BE ON GOOGLE SHEETS.