Web Applications Stack Exchange Community Digest

Top new questions this week:

Find and extract words/names from a string beginning with specific character

I've got some rows in Google Sheets that contain strings. I want to extract certain parts from this string and enter them into another cell: specifically, I want to extract words/names that begin with ...

google-sheets google-sheets-arrayformula regex  
asked by Henry Petch 2 votes
answered by Frederico Mattos 1 vote

Slack always showing the same user when starting up, even if the account is disabled

It is not really a big thing, but somehow getting on my nerves since long: Whenever I open a certain slack project, I always see the direct-messages page of a certain user as first page: I tried to ...

slack  
asked by B--rian 1 vote

Count query based on multiple conditions

I have a spreadsheet that I use for my World of Warcraft guild, and I've hit a bit of a wall while trying to add new functionality to it. For reference, when our guild goes through dungeons, we ...

google-sheets google-sheets-query pivot-table  
asked by Xen the Kobold 1 vote
answered by CodeCamper 1 vote

Make cell range appear in different position to VLOOKUP?

I want to use VLOOKUP to search the highest value in a given range, and report to me what day it's the highest. Example VLOOKUP for my actual data set in case if it matters: ...

google-sheets vlookup  
asked by udlp 1 vote
answered by marikamitsos 1 vote

Google Sheets, CountIf, name matches and is within date range from another spreadsheet

In another sheet I want to count how many meetings were scheduled for a rep within a date range. My 3 columns are the date, rep, and misc data =countifs( ...

google-sheets formulas  
asked by Matthew D 1 vote
answered by CodeCamper 1 vote

Create list of cell addresses contained in a range

I'm looking for a single arrayformula to convert a specified range, such as B2:D4, into a list of addresses (not values!) contained in that range, in this case B2,B3,B4,C2,C3,C4,D2,D3,D4. Attempts ...

google-sheets google-sheets-arrayformula google-sheets-arrays  
asked by fsteff 1 vote
answered by CodeCamper 2 votes

Strange and annoying math equations in Google Docs

I'm writing a math paper with Docs and I want to insert simple equations. Everything is fine and nice-looking until I began to use the root symbol and fractions. Regarding the root symbol, when I ...

google-docs google formatting  
asked by Sean Xie 1 vote
answered by ahorn 1 vote

Greatest hits from previous weeks:

How can someone answer my survey form or Google form without creating their own Google account?

How can someone answer my survey form or Google form without creating their own Google account? They told me that they can't open my form because they didn't have an account.

google-forms  
asked by user110597 30 votes
answered by prdeepkumawat 7 votes

How can I appear as an "anonymous animal" on Google Drive?

How do you change your title to an anonymous animal on shared Google Drive documents? I'm currently in a college class of about 150 and I'm the only person doesn't seem to know how to make ...

google-drive  
asked by Laura H 6 votes

How do I un-ignore a conversation in Facebook Messenger?

In Facebook Messenger, in a conversation with a friend I clicked on the info button (you know, the one that also has "View profile" and stuff) and I clicked "Ignore messages" thinking it just wouldn't ...

facebook facebook-messenger  
asked by Melab 4 votes
answered by Stephen Farrell 3 votes

Permanently turn off new Google Maps and go back to old one

I found new Google Maps slow, useless (routes with only two points) and wrong. Is there any way, I can turn it off completely and go back to favored old Google Maps? Or is this — as with ...

google-maps  
asked by trejder 74 votes
answered by John C 70 votes

How to make Gmail automatically label incoming emails

I would like to set it up so that Gmail labels incoming mail based on which business email of mine the emails are sent to. I have two business emails that come to my Gmail account. For instance, if ...

gmail-labels  
asked by MelyElly 37 votes
answered by ale 33 votes

How to easily add flight itinerary to Google Calendar from flight confirmation email in Gmail?

I got an email from my colleague about our business itinerary containing flight confirmation as a PDF attachment. Turns out Google can detect that it's a flight confirmation. When I search ...

gmail google-calendar  
asked by Petra Barus 33 votes
answered by Kevan Sheridan 13 votes

How do I link a cell in Google Spreadsheets to a cell in another document?

I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?

google-sheets importrange  
asked by Jeff Yates 180 votes
answered by ale 185 votes

Can you answer these questions?

How do you delete shared drives from google drive

I recently worked with a file from a link, now it is indexed in my "Shared with me" folder and is taking up space in my drive folder. It lists itself as a shared drive but I can't delete it and if ...

google-drive google-apps google-account account-management google  
asked by Ultra Gamer 1 vote
answered by ahorn 0 votes

Receiving legit emails into spam folder

On my @hotmail address, I'm receiving emails from a specific person-i-know@gmail.com address into spams, despite having the expeditor in my contact list. Not all the emails from this address directly ...

outlook.com email  
asked by Destal 2 votes

How to download Facebook archive completely?

My account got blocked, and I'm trying to download my data. The problem is my network, it's 12Mb/s, Facebook logs me out automatically after about 30-40 minutes, and the download stops. The download ...

facebook download facebook-archive  
asked by UDPSend 1 vote
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

<3