All Questions

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

Problem with Nested IF() statement on google sheets

I am trying to create a formula for a monthly expense report using the following nested IF() statement: =IF(B2="Weekdays", C2*20, IF(B2="Monthly", C2, IF(B2="Weekly", C2*4, IF(B2="Bi-weekly", ...
11
votes
2answers
3k views

Is there such a thing as a “git blame” for Google sheets

I know that one can easily see the revision history of a Google Sheet. But then that's the same as running git log.. It shows shows a chronological order of changes to the file. I'm actually ...
0
votes
1answer
9 views

Add year (multiple different years) in cells that have only day and month (Google Sheets)

I have a spreadsheet as follows in column B: 10/11 27/10 05/05 01/01 24/12 11/07 03/03 27/11 15/10 The top ones are always from the year that we are, in this example it's 2019, but according to what ...
0
votes
1answer
100 views

How can I check my storage on my OneDrive for business account?

How can I check my storage on my OneDrive for a business account? https://faq.oit.gatech.edu/content/how-do-i-check-my-storage-usage-onedrive-business says: but I don't have the "site settings" ...
1
vote
1answer
35 views
+100

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 ...
0
votes
1answer
9 views

Help with a Google Sheets formula for Inventory Tracking

Wanted to get some help with finding the correct formula to input into a cell in google sheets. I need to determine when we are getting low on product and when it is recommended to order more. I ...
0
votes
0answers
51 views

Facebook page owner

I'm trying to set up my business page on the business ad manager account. It says on there that "Your request for access is pending" I went on my Facebook page to check who the owner is and it says '...
2
votes
1answer
46 views

How can I produce unicode symbols in a slack chat?

How can I produce unicode symbols in a slack chat by typing their code? As a mathematician, I routinely need to write things like ⨐∅⊋💩. In some systems I would just use some escape character and use ...
-1
votes
0answers
11 views

Why is my file always disappearing automatically?

I have never done a delete operation, but whether it is a file on my computer or a file on a google drive, it will disappear inexplicably and cannot be found in the recycle bin, and it will still show ...
1
vote
1answer
203 views

G Suite - Allow public to send mails to a group alias

I have recently started using G Suite for my business email addresses. I am trying to set up a support@ email with multiple members by using Google Groups. How can I allow anyone outside of the ...
0
votes
1answer
16 views

How many 'importranges' are being used in a selected Google Sheet

How to find out how many importranges are being used in a single Google Sheet?
-1
votes
0answers
4 views

Averaging cells if cell contains “Word” AND the word equals a “#”

Okay, here's my issue: My students are receiving scores every week in 5 different categories. The scores are listed as "Expanding", "Competent", "Developing, and "Beginning". I need a formula that ...
0
votes
1answer
3k views

How to report impersonation of Hangout account

Someone is trying to impersonate me and has created a Google+ account and Hangouts. The Google+ account has a picture of me and I reported the impersonation of it and it was removed by Google. But the ...
0
votes
1answer
16 views

Multiple IF(AND) statements to determine Pass/Fail

I'm using Google sheets to try to generate a Pass/Fail in a cell based on two different parameters; If (R2) is less than 85% AND (I2) equals "T1","T2, or "T3" I need a fail generated. similarly, for ...
2
votes
3answers
2k views

Search in hidden rows in Google Sheet

When I search the current sheet using Ctrl+F in a Google Sheet, hidden rows aren't searched. I know I can manually unhide all the hidden rows and then do the search, but then I would have to remember ...
0
votes
1answer
634 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
271k 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
5 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
8 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
1
vote
1answer
20 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
22 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
203 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
34 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: ...
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
17 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
9 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
1answer
229 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
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
18 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
20k 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
8 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
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
23 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
6 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
3 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
26 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
17 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
4 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
11 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
15 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
155 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
26 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
338 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
416 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
65 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
604 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, ...

15 30 50 per page