17
votes
Accepted
How can I add N more columns?
Select a column where you want to add your N columns (left of there or right of there)
Shift-select the N number of columns that you want to add
Right-click
Click on "Insert N columns on left" or "...
9
votes
Accepted
How do I fill out Google applications when their own reCAPTCHA is broken?
I have heard some reports that:
Entering the shown text ("reCAPTCHA V1 IS SHUTDOWN") will let you pass.
Entering any text will let you pass.
But if that's not true, then you'll have to wait until ...
4
votes
Accepted
Text result of JOIN is longer than the limit of 50000 characters
Use a query smush, like this:
=arrayformula(
substitute(
transpose(
split(
query(
filter(
substitute( substitute(Data!C2:C, " ", "_")...
3
votes
How can I add N more columns?
I just figured out a nifty little way to do this. Even if you don't know JavaScript, this should be pretty easy to follow:
Answer:
Step 1 - Go to the script editor:
It will look like this:
Step 2 -...
3
votes
How can I add N more columns?
To add N number of Columns > Right Click on the top left corner of the sheet so that it selects the entire spreadsheet > you will see the option to add 1000 Rows
and 26 Columns.
I believe Google ...
3
votes
How can I change my username on Google Help Forums?
This must have changed as I was just able to change my user name on the Google Voice Help Forum. Here is what I did.
While in the forum (e.g. https://productforums.google.com/forum/#!forum/voice for ...
3
votes
Accepted
Disabling all Gmail's April fools
No, there isn't. Google has never offered any option to prevent their corporate pranks. Of course, in the past, most have been ones where you actually need to go to a different URL or are something ...
2
votes
Google Trends keeps coming up in Chinese
in 2019,using the "http://www.google.com/trends/?hl=en" can direct to english language on google trends,but when you type some words to search it return chinese again.
so there is another solution:
...
2
votes
How do I change my username on Trello after I set up my account with my Google account?
So, I had the same problem as Danny.
I used my Google login to create a Trello account, and didn't appreciate the 1 tacked onto the end of my username.
Surprisingly, the following worked....
Note ...
2
votes
Accepted
Change language of Google websites?
You can change the language for all of Google's products by setting your preferred language at this URL:
https://myaccount.google.com/u/0/language
To change the display language for Google Accounts, ...
2
votes
How and why are Google signing in to my outlook.com account?
This often happens when a Gmail account is set up to "gather" or collect email from Outlook.com via POP or IMAP.
It's a quite handy feature as Gmail allows you to pull those messages and have a ...
2
votes
How do I let Google know of a problem so they can fix it?
Short answer
Use Google Feedback
Explanation
Google Feedback is the tool that Google includes on many of their web applications to make easier for users send feedback directly to the engineers in ...
2
votes
Accepted
Sync Photos and Videos with Google Backup and Sync tool for Windows
By default Google gives 15 GB free space to use, which includes Gmail, Photos and Drive.
To backup and sync your photos and videos in there are three options. Two options are unlimited free to sync ...
2
votes
Multiple IF functions on a single cell
Matter is with SEARCH() returning error when failing to find your criteria.
To avoid that wrap your SEARCH() in IFERROR() like this:
=IF(IFERROR(SEARCH("wheel", A41),),"car",
IF(...
2
votes
Accepted
Is there a way to verify a username.github.io subdomain (not custom domain) with Google developer console?
You can use HTML tag to verify your site provided you can add some meta contents to your site. They would give you some html like <meta ....>
Click on try a URL prefix property. Then click on ...
2
votes
Copy/multiply cell contents based on number in another cell
Here is another approach:
=ArrayFormula(VLOOKUP(TRANSPOSE(SPLIT(JOIN("",REPT(ROW(A:A)&"@",A:A)),"@",0,1)),{ROW(A:A),B:B},2,FALSE))
How It Works
=ArrayFormula(...) ...
2
votes
Accepted
Copy/multiply cell contents based on number in another cell
Please use the following
=QUERY(ArrayFormula(flatten(IFERROR(SPLIT(REPT(B1:B&"@",A1:A),"@")))),"where Col1<>'' ")
How the (undocumented) flatten function work.
...
2
votes
Accepted
How can I know whether I am a Google One member?
Well, the first result when I Google’d “google one”
was https://one.google.com/about,
which seems to indicate that it’s an enhanced / elevated service plan,
where you pay money for lots of storage
(...
2
votes
Accepted
Ordering Google accounts
What works for me is to sign out from /u/1 - /u/3, and the new account, and then sign in with the new account. It automatically gets the lowest available number.
2
votes
Accepted
How do I use an arrayformula to autofill a column in Google Sheets?
AND() is not compatible with ArrayFormulas, you need to find another calculation.
Furthermore we cannot use COUNT() because otherwise we would obtain a value that is always valid even if there was an ...
2
votes
Accepted
Sum of Cells (supplementary question)
Wrap the scan() in arrayformula(if()), like this:
=arrayformula(
if(
sequence(rows(C3:C15)) <= xmatch("?*", to_text(C3:C15), 2, -1),
scan(0, C3:C15, lambda(a, c, a + c)),
...
1
vote
Clear Cell Script Google Sheets
When a cell in column I is edited with the value "Complete, you want to clear the contents of the cell on the same row in Column E.
Note some of the differences between this answer and your ...
1
vote
Why does "Truecaller" appear in my Google My Activity section so much?
My Activity also shows activity from outside your browser, but devices connected to your Google account such as smartphones. if you have Truecaller app installed, this will come up here
1
vote
How do you use the SPLIT function to separate unseparated characters in Google Sheets?
SPLIT will work:
=SPLIT(A2,"?",0,1)
Here, SPLIT views the split character (i.e, "?") as the same whether there is 1, or whether there are 500 of them in a row.
Of course, this can ...
1
vote
Sync Photos and Videos with Google Backup and Sync tool for Windows
For everyone experiencing the same problem, the answer is to remove unsupported videos from Google Photos, apparently, if you upload a video that Google Photos cannot process it will take up space ...
1
vote
Accepted
Backup photos and videos to Google Photos
If you delete a photo or video from your local device which is already backed-up to Google Photos, it won't be deleted from Google Photos.
To test this, backup any random photo or video to Google ...
1
vote
Accepted
Bar chart that counts rows google sheets / Pandemic-like chart
You can use a query like this :
=QUERY(A:A,"SELECT A, count(A) group by A order by A desc")
Result :
Graph :
1
vote
Accepted
Prevent products I’ve searched for appearing as Facebook ads on other devices
I expected that this only happens via cookies (and other locally stored state) combined with login accounts since IP addresses are commonly shared, including between parents and children, and your ISP ...
1
vote
Accepted
Populate Last Cell With Query Function in Google Sheet
What you need to get the desired results would be:
=QUERY({'Sheet1!'!A1:A,ArrayFormula(IF(LEN('Sheet1!'!A1:A)<>0,REGEXREPLACE(TO_TEXT('Sheet1!'!A1:A),TO_TEXT('Sheet1!'!A1:A),"TRUE"),""))})
...
1
vote
Google Finance function returns Date not Currency Conversion
When it throws up a random date, try selecting the cell and choosing Format → Number → Number.
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google × 285google-sheets × 46
gmail × 46
google-drive × 28
google-workspace × 21
google-plus × 16
formulas × 15
google-calendar × 12
google-analytics × 11
google-docs × 10
authentication × 10
google-account × 9
youtube × 8
privacy × 8
account-management × 8
google-sheets-arrayformula × 7
security × 7
google-contacts × 7
localization × 7
trello × 6
login × 6
facebook × 5
google-sheets-query × 5
google-search × 5
google-chrome × 5