Hot answers tagged

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 "...
tsoliaspn's user avatar
  • 194
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 ...
user1686's user avatar
  • 1,420
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, " ", "_")...
doubleunary's user avatar
  • 13.2k
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 -...
Spencer Healey's user avatar
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 ...
dropOFocean's user avatar
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 ...
tehDorf's user avatar
  • 131
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 ...
ale's user avatar
  • 52.3k
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: ...
losvincent's user avatar
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 ...
junckster's user avatar
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, ...
Vinayak's user avatar
  • 432
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 ...
hlecuanda's user avatar
  • 549
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 ...
Rubén's user avatar
  • 44.6k
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 ...
serenesat's user avatar
  • 9,906
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(...
Oleg_S's user avatar
  • 791
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 ...
Severus Snape's user avatar
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(...) ...
Erik Tyler's user avatar
  • 4,980
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. ...
marikamitsos's user avatar
  • 12.6k
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 (...
G-Man Says 'Reinstate Monica''s user avatar
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.
Glorfindel's user avatar
  • 2,250
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 ...
Daniele's user avatar
  • 2,338
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)), ...
doubleunary's user avatar
  • 13.2k
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 ...
Tedinoz's user avatar
  • 5,520
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
Sathyajith Bhat's user avatar
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 ...
Erik Tyler's user avatar
  • 4,980
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 ...
cyberquarks's user avatar
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 ...
serenesat's user avatar
  • 9,906
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 :
pjmg's user avatar
  • 1,968
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 ...
Jerry101's user avatar
  • 2,470
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"),""))}) ...
marikamitsos's user avatar
  • 12.6k
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.
MattKing's user avatar
  • 211

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