New answers tagged

0

You could try the following: Formula in T2: =ARRAYFORMULA(REGEXEXTRACT($S2:$S5,T1&"':\s'([^']+)")) Dragged to W2. For those who want to have a go with the data: {'gender': 'Female', 'document_type': 'driving_licence', 'date_of_expiry': '2023-12-05', 'issuing_country': 'GBR'} {'gender': 'Male', 'document_type': 'driving_licence', '...


2

Google Sheets doesn't include that as a built-in feature. Please send a feature request direclty to Google through the Google Sheets Help menu It's worthy to mention that FIND AND REPLACE can highlight / navigate through the cells diplaying an error, i.e. #N/A You could even use regular expressions to search for multiple errors.


1

Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), “Select #(Col2) where Y N(Col1) contains ‘Y’ “) one problem is that it's using typographical quotes instead of straight quotes. As second problem is that the second argument syntax is wrong. Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), "Select * Where Col2=<&...


0

To determine if cell A1 contains an asterisk, use: =if(iserror(find(char(42),A1)),"No Asterisk","Asterisk")


0

You are trying to create a match condition if a name contains "*" (asterisk). However in the question that you cited, Google Sheets formula for “if contains”, none of the REGEXMATCH answers use an asterisk. In spreadsheets, the asterisk (*) is normally a wildcard character taking the place of any number of characters. But in regex, the asterisk has ...


3

Brandon, I have added three sheets to your sample spreadsheet. "Erik Notes" has notes (as found below). "Erik Help" holds four formulas: in A2, B2, C2 and D2. Each "runs" its own column. In A2: =ArrayFormula({"Name";SORT(UNIQUE(FILTER(data!D2:D,data!E2:E=A1)))}) In B2: =ArrayFormula({"Direct";IF(A3:A="&...


0

Although the answer provided by user0 is the best solution for this, I also wanted to add an alternative workaround for this. You can use an Array Formula to duplicate the entire "BY" column in a different column and use that duplicated column in the Query formula. Check out the following G-Sheet which shows how this workaround can be implemented (...


0

There is no built-in function to automatically split pasted data into row but you can use a on edit simple or installable trigger from Google Apps Script. The edit event object includes a range property that can be used to grab the pasted values. Then you could use JavaScript to split those values into rows and then use the Google Apps Script Spreadsheet ...


Top 50 recent answers are included