All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
601 views

Repeat formula n number of times in Google Sheets

Apologies, I'm very new to Google Sheets and spreadsheets in general. I'm trying to fill some cells with repeating data, and then analyze it. The data is pulled from another large spreadsheet and has ...
33
votes
5answers
270k views

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'...
0
votes
0answers
2 views

Google Docs: Is there no way to share Revision history and changes with read-only users?

If this is true then it is very unfortunate ... one of the most useful types of information you disseminate to consumers of your documentation is to be able to easily allow them to see what you have ...
0
votes
0answers
2 views

QUERY Function with sort

I need to get data from tab 1 to tab 2 but not empty cells. I think the function QUERY should work but can´t get it to work. I made a test sheet you can check at this link: Test
0
votes
0answers
3 views

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: =VLOOKUP(MAX(A3:A1001),...
1
vote
1answer
18 views

How to get cell's parent ID?

Firstly thank you for helping me out. I'm in the construction industry and don't have any clue how to best do this - not my forte! I'm trying to bulk add a bunch of building product categories to my ...
1
vote
0answers
7 views

Does Gmail need attention?

I open Gmail, I see my emails labeled Category/Primary in my primary inbox, it's still loading, after few seconds it stops loading, and suddenly a new message is shown on top of the primary tab list ...
1
vote
0answers
6 views

Facebook Messages : Instant Reply doesn't always work

We have Instant Reply ON for messages sent to our company page's inbox. But unfortunately, the Instant Reply only replies to 60-70% of incoming messages. On the other messages Instant Reply simply ...
1
vote
1answer
201 views

How to create a pure custom color for Gmail tags

Right now I can only pick from a very limited gradient for background/text color for tabs in Gmail like so: I would like to truly customize them (i.e. provide hex values or chose from a picker). How ...
0
votes
1answer
32 views

Fetch value of a cell based on dropdown menu items results on another sheet

I have 2 Sheets named as Sheet1 and Sheet2... Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column. Sheet2: ...
0
votes
0answers
4 views

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

Thank you in advance! 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("https://docs.google....
2
votes
2answers
4k views

How can I log directly into Gmail when I am also signed into Google Apps?

Background: I have one Gmail account and two Google Apps e-mail accounts that I use on a regular basis: <my.name@gmail.com> <myaddress@teaching-job.edu> <my.name@consulting-job.com>...
1
vote
0answers
8 views

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 ...
0
votes
0answers
4 views

Google Sheets: Stacked bar chart showing event totals by month

I have a Google Sheets spreadsheet that tracks four types of events on a daily basis; we'll call them A, B, C, and D. More than one event can happen on a day; if this happens there are two (or more) ...
1
vote
1answer
7 views

Google Spreadsheet sum when filtering

I have spreadsheet that looks like this: Now when I filter on a company I want the total to display the sum of the whole of B column. Since I am very new to spreadsheets I was hoping someone could ...
0
votes
0answers
5 views

Error while creating YouTube channel - “A name has not been set for this account. Please try again when a name has been set.”

I am trying to receive ownership of a YouTube channel. But I get the error "Failed to accept invitation". Also I am not able to create a new channel. Edit I am unable to change/set the account name....
0
votes
0answers
12 views

How to get last login time of a user in Gmail?

How do I find out the last login time of a user when they log into their Gmail account?
0
votes
1answer
227 views

Change language forever

Trying to change the default language in Google Maps by settings in Menu > Language. But it sets required language just for current settings. Next time I open Google Maps I have the previous language. ...
0
votes
0answers
3 views

Unable to set nickname/change name of Google account

I am trying to change the name in my google account. I get the following error. Trouble updating your information. Please try again later.
0
votes
0answers
4 views

Verifying Google AdSense On Specific Site Sections

I'm setting up a number of Columns on my website - Some of which are U rated, some are 18+ rated. So this kind of works like an Invitation Only basis, where users are directed to my site via social ...
1
vote
2answers
16 views

How can I hide all videos from a given channel on YouTube?

How can I hide all videos from a given channel on YouTube? By hiding I mean never recommending any video from the given channel.
46
votes
9answers
19k views

How do I find the date of the first commit in a GitHub repository?

Given a GitHub repository, how can I quickly find the date of its first commit? I often want to know how old the project is, but I cannot find a quick way to get to the start of the commit histories ...
2
votes
0answers
7 views

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 ...
1
vote
2answers
24 views

Find words beginning with specific character, and isolate them

I've got some rows in Google Sheets that contain strings. I want to isolate certain parts of this string and enter them into another cell: specifically, I want to take words that begin with the ...
1
vote
1answer
13 views

Adding mm:ss times when expressed as TEXT

I have a series of numbers that, for a reason out of my control I can not change, are expressed as plain text strings on google sheets. The numbers are supposed to be minute second. mm:ss. For the ...
0
votes
0answers
12 views

How do I disable Facebook Messenger's “ping this friend” suggestion?

I'm in a group chat with a friend whose last name begins with "Ok". Unfortunately enough, this means that every time I type "Ok" + enter, Facebook autocorrects to @[friend], and I end up pinging this ...
0
votes
0answers
5 views

Any way to make the Github comment field monospaced?

With Github being a hosting platform where you write technical things, I also found it very strange that their comment field is not monospaced (like on StackExchange). Is there a convenient way to ...
0
votes
0answers
2 views

Fixed point translations

I could benefit from a fixed point indicator when translating. If I today feed Esto es así. to translate.google, it'll answer Das ist so.. On clicking the arrows button, it'll answer Así son las ...
1
vote
1answer
10 views

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 ...
1
vote
2answers
44 views

How to make sequential list of months?

I want to fill column names with a sequential list of the last day of each month. For example, 3/31/2018, 4/30/2018, 5/31/2018, etc. Is there a formula that can do this? If cell B1 = 3/31/2018, I ...
0
votes
1answer
12 views

Does GitHub have an escape character for their markup?

Background I realize that markup is implementation without a specification but it basically is just a tiny little node stemming from SGML and the like. On GitHub I always use the ` symbol with a ...
18
votes
5answers
43k views

How to disable auto-save in Google Docs?

I'm using Google Docs to edit a large document that I need to access from my 2 laptops and 1 desktop. All is good except when at office, the Google Docs always freezes with message "trying to reach ...
0
votes
0answers
2 views

How can I keep prevent my logins to GitHub from frequently expiring?

I have to log in to github.com very frequently. I was previously signed in on the browser, but some time in the future I'll visit GitHub again and I'm not signed in. How can I stay logged in to GitHub ...
1
vote
0answers
9 views

Google map directions: wait until I enter both locations

When I click on the "directions" button in Google maps, it puts "your location" in the start field and immediately starts calculating directions. So if I am looking for a walking route between ...
0
votes
0answers
7 views

Apply Filter script on multiple sheets

I made a script to filter column D3 on active sheet, I would like to do the same on multiple sheet at the same time from an action button on my index page Ex (tab1, tab2, tab5, tab7) What do i need ...
0
votes
0answers
9 views

How to turn off auto pop up messages tab and suggested conversation in facebook page?

When fan page enter my facebook page, the messages tab will be pop up automatically with suggested conversation buttons. How to turn off auto pop up messages tab and suggested conversation in ...
2
votes
2answers
153 views

Formula for PROPER Case with Apostrophe

I'm using Google Sheets glued together (not be me) from multiple sources where some of the names are in all caps. In trying to clean web-ready content, I have good success with the PROPER() function ...
0
votes
0answers
6 views

When I want to change or remove my phone number in my Gmail, it brings me to a verification page for that number which I no longer have

Gmail - I now realized that the phone number recorded in my gmail is an old number that I no longer have. Although I am able to enter my gmail using my password, when I come to the Personal Info to ...
0
votes
1answer
333 views

Spell check with formula or apps script

I have text in the table. I want to check the text whether there is a typo or not. Usually to check my typo using the default Spelling Tool from Google Sheet. The question is: Can the spelling check ...
0
votes
1answer
414 views

Migrating from Evernote to Google Docs

For numerous reasons, I've decided to ditch Evernote, and find Google Docs to be the best replacement. Now I want to migrate all my (thousands of) notes. Exporting HTML from Evernote and then ...
0
votes
2answers
60 views

Is there a keyword to search for Google results within the last x days/weeks/months/years?

Is there a keyword (see this) to search for results within the last x days/weeks/months/years? I know that you can do this by adding code at the end of the search URL, e.g. for results dating no more ...
0
votes
1answer
598 views

Choose which photos in Google Photos to change from Original to High quality

I want to save some space in my Google storage. For Google Photos, I am using Original quality, which counts against my 15Gb quota. I know I can Recover storage, which changes all photos from ...
7
votes
1answer
17k views

LinkedIn limiting number of views of public profile; requires joining/login for more views

My LinkedIn profile allows public viewing of my full profile. So even non-LinkedIn members should be able to see it, right? But that's not what's happening. I've tested on multiple computers, ...
1
vote
2answers
1k views

Is there a way to get MD5 Checksum from the files with a custom formula?

I have a Google Sheet full of important links to images on Google Drive. Is there a way to get MD5 Checksum from the files with a custom formula? Here is my scenario: No. | PHOTO | MD5 ...
0
votes
0answers
5 views

appscript upper

I have this script that works perfectly: function firstColumnUPPER() { var activeCell = SpreadsheetApp.getActiveSheet().getActiveCell(); if (activeCell.getColumn() == 2) { if (activeCell....
0
votes
1answer
24 views

Alternate to nested if statements (alternate posing of question)

Sample Data Sheet: https://docs.google.com/spreadsheets/d/1EIQcpzwdaoNSKEPu-F1NCUOtEjS6Ez0P73dmotClT7Q/edit?usp=sharing The end goal is to have a Month + Year show up in a single cell, based on the ...
-1
votes
0answers
5 views

QR code for Android messages not loading in Firefox

When I visit Google web messages (messages.google.com/web) in Firefox, the QR code does not load (see image below). I have tried the following: opening Firefox in safe-mode disabling AdBlocker and ...
0
votes
0answers
37 views

Multiplied e-mail addresses in Google Contacts

Each time I save an change (to any field) in Google Contacts, GC multiplies number of e-mails addresses I have for this contact, i.e. adds a new entry with exactly the same value. When you look at ...
0
votes
1answer
41 views

Sending an email to ALL email addresses of EVERY member in a group with new CONTACTS

I used to be able to add multiple email addresses for a single contact to a group label. Now - you can just add the label to the contact and it selects just one email address to use. How do I get ...
14
votes
5answers
15k views

How do I reset permissions for Google Drive documents in all subfolders?

OK, I've looked everywhere for the answer for this and don't seem to be able to find it. We are trying to get our Google Drive organised so that the right people get access to the right things ...

15 30 50 per page