|
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? |
|||||||
|
|
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. |
|||
|
|
|
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. . . |
|||
|
|
|
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. |
|||
|
|
