I have a monster spreadsheet with lots of contacts in it. Each contact is a row, with different attributes as columns (first_name, last_name, number, etc.). There are a hundreds columns—i.e., too many too make the spreadsheet viewable.
I would like a way to have several separate abbreviated views of this master spreadsheet that:
- show ALL of the rows;
- show only SOME of the columns;
- allow new data entered into the abbreviated view to populate the corresponding cells in the master sheet
- allow sorting in the abbreviated view that does not destroy the data in the master sheet
I know that IMPORTRANGE() allows for you to reproduce data across sheets, but it doesn't seem to satisfy (3) and (4) above.
The new filter view seems almost perfect, but it doesn't allow you to create a filter view that only shows a few columns (e.g., A:A, B:B, E:E, X:X, Z:Z, AB:AB, etc.). You can hide them manually every time you want to look at a filter view, but this defeats the purpose.
Is this possible?