3

At this time, on Google Sheets owner and users with permissions to edit a protected range are allowed to filter it. to edit saved filters. users without permissions to edit a protected range are not allowed to filter the protected range. to edit view filters created by others. are allowed to create temporary and to save view filters to edit own ...


1

Unless you want to delve into the Advanced Google Services or Filter View, a "quick and dirty" workaround would be to rename your filters giving them a serial number: 01-myfilter, 02-yourfilter, 03-onemore. Rather a practical solution of re-naming than a "Google developer solution".


1

The Google Sheets UI, the Google Apps Script service and the Google Sheets API do not include a way to sort the list of filter views on the Google Sheets UI, but the filter views are editable so you could each item in the filter view to make have the settings that you want. NOTE: Google Apps Script doesn't support filter views directly but you could use the ...


1

Here's a way to achieve this =FILTER(B1:B10, iferror(ArrayFormula( VLOOKUP(B1:B10,$A$1:$A$10,1,false)) ,true)) EDIT : If you have a lot of values this is maybe a better solution : =FILTER(B1:B10,ArrayFormula(COUNTIF($A$1:$A$10,B1:B10)-1)) Breakdown of the formula VLOOKUP: Vlookup to see if there's a match between values in B and A. It returns ...


1

Well, it's clunky, but this works: INDIRECT("R" & ROW() & "C" & COLUMN(),false) e.g. = AND(INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Financial",INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Income") I could make it a lot neater if I could pack some of this into a custom function, but I can't seem to ...


1

Instead of using the Google Sheets UI filters, use a formula to filter the results. To do this you could use functions like FILTER and QUERY


1

Apparently in Google Sheets, when you turn on the filter (say on the first row) and you don't create a named filter view, that filter on the first row is still set with a range that only goes to the maximum number of rows that you have set up at the moment you turn on filters. If you add rows (not data to existing rows, but physical rows) to the spreadsheet,...


1

Google Sheet's Filter Views only work on the range specified. This range does not update upon the adding of rows or columns. The second issue, the number not being sorted, is because of the first one. Those cells are not in the range of the Filter View.


1

I ran the test (video here) which shows what happens for each of the operations. I tested: Cut & Paste, Copy & Paste & Delete, and Dragging cells. You can see from the resulting image that the only operation that gave the expected results while in filtered view was to copy the cells, paste them, and then delete the data from the original cells. ...


Only top voted, non community-wiki answers of a minimum length are eligible