How Do You Track Changes In Google Sheets

When working on a Google Sheet with different collaborators, it's crucial to rail all changes. That way, everybody can refer to new information and stay upwardly-to-engagement.

How to Enable Track Changes in Google Sheets

Tracking and managing changes in Google Sheets is quite simple. In that location are dissimilar means to do it by enabling dissimilar functions or by using an add-on. Allow's explore them.

Track Changes past Enabling Notification Rules

The neat feature that exists in Google Sheets "Notification rules" allows y'all to e'er be informed of the changes fabricated to the certificate. Once you lot enable information technology, you'll receive emails every time at that place's a change to the canvas. You lot become to decide whether you want to receive notifications every time someone makes a change, or go a summary of all the edits.

Allow'due south run across how to do this:

Open the sheet yous need and wait for "Tools".
Curl down and click on "Notification rules".
Select "Any changes are made".
Next, under "Notify me with…" choose between getting emails right away or getting daily digest.
Click "Salve".

Track Changes by Enabling Version History

Another useful method to track changes in Google Sheets is by enabling "Version history". This function gives an overview of all edits, along with details similar who made the edits and when. Hither'south how to do it:

Open the canvass you need and navigate to "File".
From the dropdown menu, select "Version history" and click on "Run into version history".

There'll be a bar on the right side of the sheet showing the names of the editors in unlike colors. At present, all new changes will be highlighted in a color representing the person who fabricated the changes.

Track Changes with Sheetgo

At that place's an add-on called Sheetgo that allows yous to easily rail changes in your Google Sheets and have data automatically imported every twenty-four hour period. Commencement, you'll have to install the add together-on. And so y'all should open up the sheet where you lot wish to track daily changes and the ane with the necessary information. Here's how to showtime using the add-on:

Navigate to "Add-ons".
From the dropdown menu select "Sheetgo" and so "Start".
A bar will automatically open on the correct side of the canvas.

Now that you've washed that, permit's run into how to import information from the current sheet to the one where you want to runway changes.

Navigate to the sheet where you desire data imported.
Click on the "Start connecting" push button and then "Import data".
You lot'll exist able to see dissimilar sheets, so select the 1 you need.
Once yous click on information technology, y'all'll meet "Settings" choice.
Expand the "Settings" tab and y'all'll run into different options.

In one case you perform these steps, you lot'll too accept to enable "Append data" to finish the process. By doing and then, the add-on automatically appends the data beneath the previously imported data. You should too tick on "Enable transfer formatting" so that both your sheets await the same.

You can choose to name the connection for futurity references. Under the "Automated update" section, you can decide how oft and at what fourth dimension you lot desire the data import to happen. Enabling this choice and selecting the frequency of data imports allows you lot to get daily updates of the changes.

Finally, click on "Finish" to stop the process. The new data will now be appended below the existing one on a daily basis. Every day you open the sheet, yous'll get fresh information, assuasive yous to track the changes.

This add-on's useful as it simply requires a 1-time connection. In one case yous make it, yous'll be able to keep up with changes in your Google Sheets automatically and on a daily basis.

Note: You may decide to turn off "Automatic update" or change how often you want data to be imported. Refer to the section above if you want to do that.

Track Changes by Enabling "Conditional Formatting"

A visual representation of changes tin be a very unproblematic way to track all the edits. There'southward an option in Google Sheets to practise so – y'all only accept to enable it. Here's how you tin exercise it:

Select all data (the cells) where you'd similar to utilize conditional formatting.
Navigate to "Format" and find "Conditional formatting".
In the dropdown menu, nether "Format rules", you'll see "Format rules if…".
Here you'll take to select "Is not empty".
Adjacent, under "Formatting fashion" you can choose the background colour or font of the letters.
Click on "Done".

Let's say yous choose blue equally a background colour. If a person enters data or makes changes to the formatted cells, the cell where they do it turns blueish. Simple as that!

Track Changes by Enabling "Cell History"

If you lot wish to track the changes made to merely one cell, y'all can practise it by enabling the new "Prison cell History" option. This allows you to see the name of the collaborator who made the change and the timestamp of the change. Hither'south how to do information technology:

Right click on the cell and click on "Show edit history".
You'll run into the arrows which you tin move left to right to run into the edits.

Congratulations!

At present you lot'll have no trouble turning on track changes in Google Sheets. In that location are various methods to do so. You tin can enable "Notification rules", "Version history", "Conditional formatting", "Cell history", or get an add-on such as Sheetgo.

Take you tried whatsoever of the methods before? Which 1 works best for you? Let usa know in the comments below.