Hi, I am a chemical producer.
I have a guy that weighs the chemicals, and a second guy that mixes the chemicals thereafter.
As a quality check, I want to check if the mixer is using the correct ingredients which the first guy has weighed
This is what I have at the moment:
1. I have 2 different google forms which populate 2 different response sheets
2. The 2 forms are the same and capture the same data.
3. Each form is done by different person
I need the following:
1. I need the 2 response sheets to be compared live as data is being captured
2. If the data does not match, I require email to be sent out