You can also set permissions in a few ways: You can either restrict this (to specific people) or you can make it so anyone with the link can edit it. You can send a document link to people.You can send the document to specific people. This is generally the most secure option.Once you’ve shared your document with others, you’ll see who made what change. But tracking changes is usually most useful when you’re sharing a document with others. Of course, you can also track changes even if you aren’t sharing your document. When wouldn’t you want to be notified? If you aren’t concerned about when changes are made, but you just want to be able to go back through prior versions, you can do that through version history. Now, you’ll be emailed when changes are made, and you can reference these emails to track changes. But if you need urgent notifications, right away is best. If there will be a lot of changes, a daily digest is the best solution. How you should be notified. This can be set to either “Email – daily digest,” or “Email – right away.” This is up to your personal preference.So, we want to select “Any changes are made.” When you should be notified. This can be set to either “Any changes are made.” or “A user submits a form.” In this case, we’re tracking changes.
There are two parts to notification rules: Now, you will want to be notified of any changes in your sheet. At any time, you can go to “Protect Sheet” to view the protected sheets and ranges that you’ve already set. You can either protect an entire sheet within the document or specific columns. If you have another administrator, for instance, you might want both yourself and them to be able to edit these cells. Restrict who can edit this range.You can choose to limit editing to yourself or to specific other people.This is used for gentle warnings that can be ignored. Importantly, they can override this alert if they choose. Show a warning when editing the range. Every time someone tries to edit a cell within this range, they will receive an alert warning them not to.Select the cells that you want to protect.In this case, you might want everyone to be able to see the budget and add transactions, but you might not want them to edit the instructions on the top of the page. If, at any time, you saw changes that you didn’t agree with, you could use the version history kept in Google Sheets to revert the changes that had been made.īefore you share your sheet, there may be areas of the sheet that you want to protect from unwanted errors. Finally, you would share the document with the people you want to share it with. You should start by protecting any sheets you don’t want to change. Not sharing the document isn’t an option everyone has to work on it at once. Let’s say that a non-profit organization is trying to share its budget between three people and wants to make sure that any changes are visible. While it may not be as elegant as just clicking “Track Changes,” it’s actually a very flexible solution. Together, these functions make it possible to be notified of changes, see changes, and prevent changes. You can protect a certain sheets or data ranges from changes.You can see the complete version history of the document.You can see the history of changes for a cell.You can be notified when changes occur.Instead, you have to track changes using a few other functions:
#TRACK CHANGES IN GOOGLE SHEETS SOFTWARE#
Google Sheet track changes don’t work like some other software like docs which have a feature that shows all changes automatically. You can then revert back to previous information. Tracking changes makes it possible to see which edits and changes occurred and when. Why Would You Track Changes in Google Sheets?
0 kommentar(er)
