Keeping track of original data after changes are made
Hi, I am using a form to send to employees when items are missing. They will have the ability to update the form which directly updates the sheet once they have resolve issues. I want to be able to keep track of when they have issues so we can use later for training. How can I keep a record automatically of the items that original where mark no but get changed to yes once they review. Is that possible? I started with a report but once the info updates on the sheet the report updates, I want to keep a record of the original data. Is this possible?