Web Applications Stack Exchange Community Digest

Top new questions this week:

Categorize text in Google Sheets based on matching partial text in the Category index

I'm looking to match, with VLOOKUP, part of the words in a column in the main sheet to an index of keywords/categories where partial words are stored for ease in another sheet. Here's an example ...

google-sheets vlookup  
asked by PKHunter 2 votes
answered by Rubén 2 votes

Trying to add multiple formulas in one cell

I'm very new to Google spreadsheets and I'm trying to add muliple formulas in one cell. This is my code so far, I'm not very good at formulas. ={SUBSTITUTE(C:C,"wd","Web Development&...

google-sheets formulas  
asked by Riley Jones 1 vote
answered by Erik Tyler 2 votes

How to modify this existing post of script and/or steps so it functions to automatically empty Gmail Trash?

I found this post on how to do the above but it doesn't appear to work? Here is the error message Nov 25, 2020, 3:52:51 PM Error GoogleJsonResponseException: API call to gmail.users.threads....

gmail google-apps-script  
asked by Kippen 1 vote
answered by Rubén 1 vote

Locking a formula when adding rows

Currently I have this formula in there =IF('Form Responses 3'!G$20="","",COUNTIF('Form Responses 3'!G$1:G$167,F20)) It does what I want it to do if I go in a tweak it later, but I ...

google-sheets formulas  
asked by Alicia 1 vote
answered by Rubén 1 vote

Greatest hits from previous weeks:

How do I retrieve a message I accidentally archived in Gmail?

I was trying to mark an email as "Important" in Gmail and accidentally archived it. Now I cannot locate it, since there is no "archive" label anywhere. How do I get it back?

gmail gmail-archive  
asked by Sharon 150 votes
answered by Andrew Maiman 98 votes

How to update Facebook Profile without announcing it to everyone?

How do I update my profile Basic Info, such as location, education, job, etc. without triggering a notification on Friends' Notification (upper left) or their Wall/Timeline/Recent Friend Activity page....

facebook facebook-timeline facebook-privacy  
asked by user58446 6 votes
answered by SleepingGod 8 votes

Change a Facebook 'page owner' (not admin)

I am a page admin along with a few others. There is now a 'Page Owner' listed on top, and it's a company. I'm assuming this is a business account? How can this page owner be changed? Who has the ...

facebook facebook-pages  
asked by vulgarbulgar 6 votes
answered by Tim.Vodien 3 votes

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 ...

asked by CWilson 40 votes
answered by CWilson 57 votes

Semi-transparent background for Google presentation text box

Is it possible to set the background of a text box in Google presentation to be semi-transparent? All I see are options to either transparent (a.k.a. "no fill") or completely opaque text boxes.

asked by David 38 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 'itinerary'...

gmail google-calendar  
asked by Petra Barus 36 votes
answered by Kevan Sheridan 14 votes

Logout out of all devices for a Google account

I want to force logout on all devices signed into my Google account. I don't actually use Gmail with this account, I use it for primarily for Drive and Calendar. Recently I've logged into a few third ...

security google-account logout  
asked by sam 7 votes
answered by ale 5 votes
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