by Allen Wyatt
(last updated December 20, 2013)
When you are collaborating on a spreadsheet with others, it can be a great boon to get everyone's changes all in that single spreadsheet. When your collaborators are all over the country (or the world), it would be great to be notified whenever someone makes a change in the spreadsheet. That way you wouldn't waste time continually checking the spreadsheet to see if others have made changes recently.
Fortunately, Sheets does provide a way to get notifications when things change in a shared spreadsheet. Here's how to set up your own notifications:
Figure 1. The Set Notification Rules dialog box.
Notifications can be set on a spreadsheet-by-spreadsheet basis, but (again) only for shared spreadsheets.
When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...Discover More
Need to share your spreadsheet with others who may not be using Google Sheets? Here's an easy way to export your ...Discover More
Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.Discover More