Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

When two or more users view the same Google Docs spreadsheet and one of them filters the data by a column, that filter is immediately applied for the other users as well.

Is there a way to avoid this and allow each user to have his/her own filter criteria?

share|improve this question
4  
The solution is here :) productforums.google.com/forum/#!category-topic/docs/how-do-i/… –  user20151 May 16 '12 at 22:02
    
@ricko Thanks for sharing this! I needed this for a tasklist assigned to several people, so the list view would have been just fine. I'll keep this in mind for whenever I need it. –  w0lf May 17 '12 at 7:39

4 Answers 4

up vote 6 down vote accepted

I have checked the related Google Groups and Support threads. Obviously, it's not supported (and looks like no soon plan to be, although not 100% sure about this one).

The way I do now is export to Excel and apply the filter there, then find a likely unique value (or repeats few times) in the sheet to correlate the row in the Google Spreadsheet (by finding it in the Google sheet) and apply the required modifications. Not optimal, still hoping for per-user fllter support.

share|improve this answer

The "List View" in the menu allows the user to filter without changing the view for the other users. However, they have to edit and submit the values for each row which is a little more cumbersome.

share|improve this answer
    
user20151 already gave this solution (but not as an answer...) –  Jacob Jan Tuinstra May 21 '13 at 20:41

Now Google Drive has a feature called “filter views”. It makes some filters available only to you while you don't change any data.

Use filter views in the new Google Sheets

In Google Sheets, filtering your data makes it easier for you to view and analyse data by letting you hide data that you want to temporarily take out of view. The new Google Sheets introduces filter views as well, which allow you to create, name, and save filters that you can use without disrupting how others are viewing your spreadsheet.

Creating a filter view

When you create a filter view, it’s like saving a filter that you can use over and over again.

  1. Open the spreadsheet where you would like to create a filter view.
  2. Click the Data menu, hover over “Filter views…” and select Create a new filter view. You can also click the down arrow to the right of the filter icon and select Create a new filter view.
  3. Using the down arrows in the column headers, sort and filter the data to fit your desired view. Your filter view will be saved as you make changes.
  4. To close your new filter view, either click the X in the top-right corner of the spreadsheet or click the down arrow to the right of the filter icon and select None.

filter view

Source.

share|improve this answer

Same issue still exists. We are getting around it by creating separate sheets for each user that reference the main sheet, but with 'if then' logic applied to only show the info pertinent to that user. Other user's rows are programmed to appear as -----. That user's sheet is now a filtered duplicate of the main sheet that can then be filtered more as needed without messing up anyone else's view. We are now going to create another sheet that references the users' sheets, without pulling the ----- cells. The reason being that the users can now edit their sheets, and all changes will appear in the final sheet. It makes the main sheet a 'rough draft', and the final sheet the edited version. That's the plan anyway. . .

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.