Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) is the outcome, ...
I have a Google Docs spreadsheet in the format below — here's an example. Column A → Dates Column B → Numbers I'd like to sum values in column B in a range of dates in column A. Example: ...
I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content. I have ...
The best workaround I have found so far is: worksheet_name!$A$1:$YY but ideally I would like to be able to simply write, e.g.: worksheet_name! So, does anyone know: is there a syntax for ...