Add a “sort” to a =QUERY statement in Google Spreadsheets
You can use ORDER BY clause to sort data rows by values in columns. Something like If you’d like to order by some columns descending, others ascending, you can add desc/asc, ie:
google sheet
Conditional Formatting from another sheet
For some reason (I confess I don’t really know why) a custom formula in conditional formatting does not directly support cross-sheet references. But cross-sheet references are supported INDIRECT-ly: =A1>INDIRECT(“SheetB!A1”) or if you want to compare A1:B10 on SheetA with A1:B10 on SheetB, then use: =A1>INDIRECT(“SheetB!A1:B10”) =A1>INDIRECT(“SheetB!”&CELL(“address”,A1)) applied to range A1:B10.
How do I filter view two columns OR instead of AND?
Click on Column D. On the menu click ‘Data’. Select ‘Create a filter’. Click the filter icon that appeared at the top of Column D. Select ‘Filter by condition’. Click the ‘None’ box and scroll down to ‘Custom formula is’. Select and enter =OR(D:D=”x”,E:E=”x”) in value or formula. Click OK. Alternatively, you can create a new sheet … Read more