All Questions
12 questions
0
votes
1
answer
31
views
\ Operator not getting included in the SETFORMULA
I am executing an apps script which sets a formula in a cell as below
var a16_range = a4_range.getA1Notation();
formula_5 = `=INDEX(MAX(LEN(IFERROR(REGEXEXTRACT(TO_TEXT(${a16_range}),"(\..+)"...
- 448
0
votes
1
answer
77
views
Is there a way to tweak this formula to make this work, even if the name doesn't 100% match? If so, how?
I'm trying to use a script to automatically set up conditional formatting to highlight a specific set of names in a Google Sheet. The data comes from a Google Form where people enter their own name. ...
- 71
0
votes
2
answers
996
views
Extract first/second/third word containing X in google sheets
Is it possible to extract pieces of text in a sentence containing X in a google sheet. In a Formula of via Apps script. I couldn't find a decent answer on google or didn't know what to search for.
For ...
- 199
3
votes
5
answers
5k
views
Fuzzy matching in Google Sheets
Trying to compare two columns in GoogleSheets with this formula in Column C:
=if(A1=B1,"","Mismatch")
Works fine, but I'm getting a lot of false positives:
A.
B
C
MARY JO
Mary Jo
...
- 89
2
votes
4
answers
2k
views
Split string and then remove prefix in Google Sheets
My Google Sheet is populated with a string of the following format:
Monday: 12:00 PM – 12:00 AM,Tuesday: 12:00 PM – 12:00 AM,Wednesday: 12:00 PM – 12:00 AM,Thursday: 12:00 PM – 12:00 AM,Friday: 12:00 ...
- 115
3
votes
4
answers
1k
views
Format Phone Numbers in Sheets using Google App Script from 1xxxxxxxxxx to xxx-xxx-xxxx
I am trying to modify the following Google App Script to convert phone numbers from
11-digits to 10 digits with hyphens. So the script would need to remove the leading 1 and add the hyphens.
For ...
- 31
0
votes
3
answers
714
views
How to get the first part of this string using Google Sheets or SQL
I have a string like "AA_BB_CC_EEE_FF_GGG".
Instead of these letters there can be any letters or numbers
How I can get the first part of this string "AA_BB_CC_EEE" using Google ...
- 57
-2
votes
1
answer
1k
views
Google sheets query "match" (regex) not working on text cell, but "contains" does work
I have email body text in a column (populated using Google apps script getPlainBody() in my script), and I am trying to query it for a match. Because I will have several OR and AND statements using ...
- 9
1
vote
1
answer
1k
views
in Google Apps Script; using Regular Expression & Conditional formatting - to create a IPv4 address validator / checker
in Google Apps Script; using Regular Expression & Conditional formatting - to create a IPv4 address validaton / checker
1. VALIDATING the input with regular expression :
I try to make a script to ...
- 314
2
votes
2
answers
9k
views
How to get/extract the link and text of a Google sheet cell? [duplicate]
Can we get the text and link URL from a cell created in a Google sheet and save the result using either a formula or script into 2 cells: text and URL?
1
vote
3
answers
10k
views
Removing a row containing a specific text in Google Sheets
I have a data set of around 3000 columns, but some of the columns have several cells that contain cells "na". These rows have no importance since they don't have data that I will need, is there a ...
- 125