Keeping track of original data after changes are made

sholmes
sholmes ✭✭✭✭✭

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?

Best Answer

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    Answer ✓

    Hey @sholmes ,

    An idea would be to have an Archive sheet, so every line that is entered to the main sheet will be copied with automation to the Archive before any changes are made in the row.

    Would that solve it?

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Answers