Is there any way for multiple users working on a Google Sheets to freeze columns and rows the same way filter view works?
Google-sheets – Freeze columns in Google Sheets for multiple users
google sheets
Related Solutions
In a new adjacent column, let's call it Merged, add the JOIN formula. Below is an example with =JOIN(" and ", B2, C2). Then drag to duplicate the formula in the rest of the column. In your case you might use a comma ", " instead. But that's the gist of it.
More info on the formula here.
No, not without something like Google Apps Script (see for example here).
Related Topic
- Google Sheets – How to Freeze Multiple Separate Rows
- Google-sheets – How to save a view in Google Sheets
- Google-sheets – Pasting timestamp for edits by multiple users in Google Sheets
- Google-sheets – Hide columns / rows for theself only not other users
- Google-sheets – Google Sheets formula for unique values across columns
- Google Sheets – How to Filter and Match Multiple Columns
- Google Sheets – Formula to Find Rows with Matching Values in Multiple Columns
Best Answer
No, that isn't currently possible.
However, if the spreadsheet is used for viewing data (and not entering or modifying) you could make a new spreadsheet for each user, and use
importRangefrom the "master" spreadsheet in each copy's "A1" cell. Each copy can then freeze/hide/filter as they please and their data will update almost in real-time as the master spreadsheet changes.One dissadvantage is that you will lose some collaboration because making a cell comment etc will only be in each user's copy, so for adding comments or modifying you need to go to the master.
As a bonus, you can add an extra sheet on each of the copies and put a link to the master spreadsheet there so its easy to go to the master.
importRange: https://support.google.com/docs/answer/3093340?hl=en