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.
No longer need a previously defined named range? Here's how to get rid of it.Discover More
Need to know what the day of the week is? Sheets provides a handy function that can return a numeric value that represents ...Discover More
As your spreadsheets get larger, it can be hard to find some information. You may also want to replace some existing ...Discover More