Hot answers tagged

2

Based on this response set, and my reading of the manual, the answer is strictly NO. it is not possible to do the boolean | or function, distinct from the boolean & and function: you can do implicit OR by a list of labels, and you can do implicit AND by using search: with at least one


1

Google Sheets do NOT highlight specific words in text. Google sheets ONLY show the cells where your search terms are included After finding the right sheet, use your browser's search feature. Please pay attention on the counted results. Google Sheets function ONLY shows found cells (including the search terms) This is what you see in Google Chrome: ....


1

According to twitter's help center: Note: Changing your username will not affect your existing followers, Direct Messages, or replies. Your followers will simply see a new username next to your profile photo when you update. We suggest you alert your followers before you change your username so they can direct replies or Direct Messages to your new ...


1

As I can see you need a report about all cells with data validation rules. The next code creates the sheet with name 'dataValidation report' into the active spreadsheet and puts a little report to there. function genDataValidationReport() { var res = Sheets.Spreadsheets.get(SpreadsheetApp.getActive().getId(), { fields: 'sheets(properties(title),data(...


1

Inspired from the accepted answer, here is the version if you want to find in notes in all sheets: function searchNotes() { var allSheets = SpreadsheetApp.getActive().getSheets(); var sheet = SpreadsheetApp.getActiveSheet(); var cell = sheet.getActiveCell(); var searchTerm = cell.getValue().toString().toLowerCase(); var results = []; for(var ...


1

In Chrome you can manage search engines used in the address bar and customize the keyword. Settings -> manage search engines, or right-click the address bar and click Edit search engines. Under "Other search engines" click Add Now to search for a stock, type this in the address bar $ kors And it will automatically go to https://finance.yahoo.com/quote/...


1

Amazon changed layout a bit. The Search Option still there and got expanded. At the end of the summary for reviews section, click on the blue number that has how many reviews a product has. Then, scroll down to the bottom of the first list of reviews they give you and click "see all (# of reviews)". The search button is on the left.


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