Danny Quelch

Protect, notify, filter, chat etc.: 6 collab secrets of Google Sheets




If you’re a Google Sheets fan you probably know multiple people can co-author documents and do simultaneous editing but here are some advanced features that allow you to work more effectively with other users such as set up filters that don’t apply to other users, check cell by cell, who edited what, when, restrict a range or sheet to a specific user and some other tricks. Here is what we cover:

00:42 – Cell by cell edit history
02:28 – Filter views
04:09 – Restrict editing
05:58 – Assign Tasks
07:55 – Chat
08:17 – Notification rules

One thought on “Protect, notify, filter, chat etc.: 6 collab secrets of Google Sheets

  1. Thank you for the video! Very helpful 🙂 I’m trying to protect a filter…so, using your spreadsheet, a user invited can only see the rows with M checked, they do not have access to any rows where M is unchecked. Is this possible?

Leave a Reply

Your email address will not be published. Required fields are marked *