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.
There are times when you don't want to mess up a spreadsheet, but you want to try out some changes. This is when making a ...Discover More
Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as ...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