Web Applications Stack Exchange Community Digest

Top new questions this week:

How to combine multiple sheets and sort the results in Google Sheets?

I have a "main" sheet like this (which is single words, not compound words): And I have a compound word sheet like this: Notice the slightly different columns. How do I combine both lists, ...

user avatar asked by Lance Score of 2

How to make a drop down dependent on a dropdown?

I work with a building company. I'm attempting to keep track of the Job Site and the Work completed at that Job Site by the labourers. At the moment I have a drop down with a long list of Job Sites, ...

user avatar asked by Jonno Score of 2
user avatar answered by Oren Score of 0

Using INDIRECT and a cell reference to compare values on sheets

Simple story - driving me cray cray. I have a single Google Workbook with sheets within with separate names (Sheet1, Sheet2, etc). I have a separate sheet called Compare that I want to make formulas ...

google-sheets google-sheets-cell-format  
user avatar asked by Sanford Score of 2
user avatar answered by David Tan Score of 1

Query to extract unique values from 1 column and add matching numeric values

I have multiple sets of 2 columns (COL_LEFT and COL_RIGHT) and would like to extract all the unique values (except the blanks) from COL_LEFT and display matching values from COL_RIGHT alphabetized by ...

google-sheets google-sheets-query  
user avatar asked by YBB Score of 2
user avatar answered by David Tan Score of 0

Query Formula and Multiple Columns

I tried to use Query function and it was functioning well at first. I initially only had 7 columns. However, when I tried to use to my document with up Column AZ, it is not working anymore. This was ...

user avatar asked by Vera Score of 2
user avatar answered by doubleunary Score of 0

How to show validation error on linked sheet in Google Sheets?

I have a spreadsheet, with this linking all the subsheets to a "main" sheet. =QUERY({ IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "custom!A:E")...

user avatar asked by Lance Score of 2
user avatar answered by doubleunary Score of 2

Insert URL inside Google Spreadsheet [escaping characters?]

OK, the big picture is to use all my API Steam results inside Google Spreadsheet so I can create a database of my games and profile. note: I don't want to share my private STEAMID for security reasons ...

google-sheets formulas  
user avatar asked by Satoshi Nakamoto Score of 1
user avatar answered by Satoshi Nakamoto Score of 0

Greatest hits from previous weeks:

How do I undo a thumbs down on Pandora?

I accidentally gave a thumbs down to a song I really like. Does anyone know how to undo a thumbs down for a song on Pandora's website? Edit: I can't reach the song in my immediate history

pandora music streaming  
user avatar asked by ahsteele Score of 39

How to view and download old Twitter Direct Messages

I'm looking to view and archive all my old DMs in Twitter, since I would like to revive conversations that took place 1 year ago. Acording to Twitter they don't delete old messages, they simply ...

twitter twitter-archive twitter-direct-message  
user avatar asked by bbonamin Score of 11
user avatar answered by silpol Score of 4

How do I remove an account from Google multi-login?

I have three accounts among the multiple accounts I have for Google's products. One of them belongs to a friend who accidentally made his account one of mine when he was using my PC. How do I remove ...

google-account google-multi-login  
user avatar asked by David Faux Score of 22
user avatar answered by Steven Roose Score of 12

How to turn off Insert/Overwrite in Google Spreadsheets

When editing text in Google Spreadsheets, in the formula bar, or editing the name of the sheet, overwrite is toggled, and pressing the insert key (numberpad or 'regular' insert key, numlock active or ...

user avatar asked by CWilson Score of 43
user avatar answered by CWilson Score of 62

Twitter account still logged in on friend's phone

I just changed my password, but one time I used my friend's mobile phone to access my account using the add account feature. Sometimes she uses my account to write or read something, and she still ...

twitter passwords mobile  
user avatar asked by Dany Score of 3
user avatar answered by Deepak Kamat Score of 2

How can I recover my Gmail account when I remember the password, not the username?

I have a Gmail account that I haven't used in ages so I've forgotten the login name I used to sign up with. I've forgotten the recovery e-mail address setup on the account but I can remember my ...

gmail google-account account-recovery  
user avatar asked by ChrisF Score of 8
user avatar answered by phwd Score of 4

No Add Friend Button but many mutual friends?

An old friend and I have 18 mutual Facebook friends. Until a month ago, I could have sent him a friend request, as the button to add friend was there. Then all of a sudden, the "add friend" button ...

user avatar asked by Michelle Score of 10
user avatar answered by NoNameProvided Score of 4

Can you answer these questions?

How Can We Schedule A Comment On Reddit?

Similar to how Gmail & Twitter does it. Multiple source outlets are saying you can schedule Posts on Reddit so that it sends at a later date. So can you do it with comments too? If so then how

comments website reddit news-feed forums  
user avatar asked by Isaiah Jordan Score of 1

Use reverse geocoding to get an adress as variable

I am trying to make it so when a truck driver presses a button when he starts for the day, i can see what his location is at that very moment so i know where my drivers are starting from. I am trying ...

html javascript geocoding  
user avatar asked by Rebel Score of 1

Is it safe to remove an original administrator user in Google Workspace?

I have an administrator and a normal user in my Google Workspace subscription. I would not like to pay for two users when in fact I use only one. I gave administrator rights for the normal user and ...

google-workspace g-suite-administrator  
user avatar asked by Gergely Score of 1
You're receiving this message because you subscribed to the Web Applications community digest.
Unsubscribe from this community digest       Edit email settings       Leave feedback       Privacy
Stack Overflow

Stack Overflow, 110 William Street, 28th floor, New York, NY 10038