Live collaboration is a great way to bring remote teams together, but itÌýcan be annoying at times. Let’s say you are working on a task list and your teammate decides to filter the spreadsheet data. Poof! The whole data view changes for you, making you lose context and eventually halting your work.
ToÌýsolve this problem, we are happy to present user-level filters in ×îв©²ÊÍøÕ¾ Sheet. With this update, the filters that you apply will not be reflected forÌýothers, meaningÌýyou and your collaborators can now apply personalized filers on the same spreadsheet without hinderingÌýeach other. Each user’s filter will be rememberedÌýupon opening the file, so you can start workingÌýright whereÌýyou left off.
Saving named filtersÌý
If you have specific criteria-based data that needs constant monitoring,Ìýyou can now create and save filters with the desired conditions. These named filters will be accessible to all the collaborators (including those with read-only permission) in the spreadsheet, thus making it easy to study data without having to choose the filter conditions repeatedly.
Ìý
Set filter as defaultÌý
The revamped filter also allows you to choose which filter should be applied by defaultÌýwhen users open the file for the first time. ThisÌýworks for published spreadsheets too. For example, you can set a predefined filter to display only the tasks that are pending.
The next time your collaborator applies a filter, youÌýwon’t feel a thing!ÌýClick here to learnÌýmore aboutÌýhow to use user-level and named filters.
Try out the collaboration-friendly filters andÌýleave your feedbackÌýin the comments below.
Comments