All Questions

Filter by
Sorted by
Tagged with
1
vote
2answers
137 views

How to create a formula in Google Sheets that can sum specific cells based on multiple criteria

I am wanting to create a formula that will look at a dozen different cells and sum to the total value of those cells but some cells will not be numbers and I want to exclude those cells in the sum. ...
1
vote
0answers
119 views

Facebook Business Manager Active Request not showing up

When I request to access a Facebook Page it states: "Your Business Manager Already has an active request on this Page. You'll see a notification if the request is accepted." But then when I go to my ...
0
votes
1answer
13 views

Google Sheets - search multiple columns for specific text

Info added after as response to first comment: I just realized that the IF(PAGE1!C5="OPTION1" probably wont work, probably because I haven't described the wish good enough. I will describe with this ...
1
vote
2answers
328 views

How to open multiple images from Google Drive at once

I want to be able to select multiple (30+) jpeg/png images from a folder in Google Drive. I then want to open all of those images in a new tab for each one. This could be achieved by individually ...
2
votes
1answer
41 views

Reference formulas from one sheet into multiple sheets

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced. For example, if I have =...
2
votes
1answer
25 views

Why am I receiving access requests on my “Public on the web” Google drive folder?

I've linked a variety of Google Drive folders containing public documents to my organization's website for ease of updating. These are all set to "Public on the web" as seen here: So clearly not ...
0
votes
1answer
160 views

How do I remove custom currencies in Google Sheets?

In Google Sheets, you can add custom currency things under the formatting tab and google sheets with keep them saved. I was playing around with this function and added a few ones to test it out but ...
1
vote
1answer
17 views

Convert ARRAYFORMULA output from 2D to 1D range

tl;dr How to create an 1D range from a 2D range output of an ARRAYFORMULA. Intro I have a Google Sheet that uses a very complex ARRAYFORMULA to perform data validation on about fift cells in a row. ...
12
votes
10answers
14k views

Is there a way to get Google translate to give you both the du/Sie and tu/vous forms in German/French?

When I type in "do you want to go?" into Google Translate it gives me in French: voulez-vous aller? and in German it gives me willst du gehen? Is there a way to change the settings so that it ...
0
votes
0answers
4 views

Can you use Google Takeout on a suspended account?

Google occasionally suspends user accounts. This can potentially be a major problem for the user, if the user keeps important documents in drive, or relies on Gmail or YouTube, or uses an Android or ...
0
votes
0answers
8 views

How can Google Search display URLs under titles?

I've the same hitch as this and Jules Wang. I'm using Win 10. When I'm logged in my Google account, my search results have recently started to look like image 1 below, with the url above the page ...
0
votes
1answer
9 views

Can the order of items in Google Drive sidebar be changed

I'd like to change the order of the items listed in the Google Drive sidebar - I often access starred items and would like that to come right after Google Drive (in the default location of Computers). ...
1
vote
0answers
2 views

Analytics gets hundreds of users, no hits and no way to filter

For the past week my GA has been getting random jumps of hundreds of 'active users' on my account, with 0 data to go with them. I get no new page hits, location data, events, or other data, just users....
2
votes
3answers
2k views

Geographically restrict access to Gmail

I heard of some people whose accounts were hacked from countries they never visited (or plan to visit), so I was wondering if you could restrict the area from which you can access your Gmail account. ...
0
votes
0answers
11 views

Help me Grab this Website!

Hello Everyone, I have enrolled in a language course on www.koreanclass101.com and they gave me a 7 day free trial. There are 15 lessons (each one has 10-25 audios). Now i want to download/grab all ...
0
votes
0answers
5 views

Excluding 0 in color scaling

I have a list of numbers that I want to color scale, with the lowest being red and green being highest. But the list sometimes includes 0's, I don't want the 0's to be included in the color scaling ...
0
votes
0answers
8 views

Library PHP or platform to send messages Whatsapp without open it in app

I need to send messages (text and vocal) Whatsapp from my Progressive Web App without open in the app (Whatsapp). Do you know a library PHP or platform to do this? At the moment, I create text ...
15
votes
3answers
17k views

Is there a way to add all items in an Amazon wish list to your cart?

For example I created a wish list of the books needed for my fall classes. Is there a one click (or other short/easy) way to add all the items into my cart other than clicking on "Add to Cart" for ...
0
votes
0answers
15 views

Shortcut on Facebook app to manage your pages

I'm managing a few pages on FB which I would like to easily access from within my menu bar in the FB app. However, I only see one of them there and the second one is missing. I can't figure out how ...
3
votes
4answers
2k views

Is there a way to hide the Google Calendar sidebar / navigation pane?

Preferably I want to be able to toggle the sidebar on and off. I tried several user scripts on Chrome but they didn't seem to work.
4
votes
1answer
7k views

Show a time-stamp in one cell when another cell is updated in Google Sheets

I want to time stamp when a cell was filled out in the column to the right of only certain columns. We use a simple spread sheet to keep inventory and I'd like to know when someone takes something or ...
0
votes
0answers
7 views

How to automatically search a website and provide alerts

I am looking for a way to automatically and periodically search websites and to receive an alert when new content is available. I am referring to something more complex than what Google Alerts can ...
0
votes
1answer
82 views

How to apply conditional data validation when a cell with a defined value is changed?

I have a spreadsheet that's basically a grid checklist, let's say 10 columns and 20 rows. There are multiple cells that have N/A as the value, and I'm worried going through the checklist that one ...
4
votes
2answers
6k views

How to duplicate a graph in Google Docs and use a separate source/link of data

When I copy and paste a graph in Google Docs, it makes 2 graphs, linked to the same spreadsheet. I'm looking to make 100 identically-styled graphs and quickly modify each one by editing the data in ...
1
vote
1answer
14 views

Storing a file in Google Drive using download link

I want to upload a file in google drive using the download link; in fact I want google to download my file and store it to its drive. I've search the web but no way except downloading the file, then ...
1
vote
0answers
18 views

Remove ssh keys in github from command line

I'm creating a script in bash to install and configure all my workspace. How do I remove my ssh keys in github from command line? I already search about and found this command, but this is ...
0
votes
0answers
41 views

Non-Google incoming emails in my Gmail inbox

If I create a Gmail account using my non-google school address, do I receive emails sent to my school address in my Gmail inbox? if so how will the automatic forwarding rule set in my school account ...
2
votes
2answers
3k views

How can I transfer Google contacts with photos to another account?

When I export my contacts from Google Contacts (contacts.google.com), none of my contact's photos are included. Additionally, when I attempt to import a VCF file containing photos, the web interface ...
0
votes
2answers
574 views

Cannot Find Function 'getRange' in Google Script

I'm working on setting up a series of scripts for a google sheet where I want to be able to auto sort based off of when something gets entered into the third column, sorting first by the first column (...
0
votes
0answers
14 views

How to google-search for one term with any suffix? Are there better search engines?

I am trying to find German laws about occupation. The German word for "occupation" occurs as "besatz..." with any possible ending. I tried adding {*} behind the root term {besatz}. But searching with ...
0
votes
2answers
52 views

Setting up a recovery email

I moved to another city and changed internet providers. My old email address is associated with my old internet provider (Frontier). The people at Frontier said they will continue to keep this email ...
0
votes
1answer
15 views

Show each n-th column, hide others in Google Sheets

I have several big tables, and I know that each 4th column is interesting for me, i.e B,F,J,N, etc (The total number of columns is different in different documents) Is there an easy way (some sort of ...
2
votes
0answers
8 views

Can't change anything under 'More Info' for page

I am trying to change things like Current Location and Genre under the section More Info. This section is last in the About tab. My page has the category Musician/Band (not sure if that makes a ...
14
votes
4answers
26k views

Google Translate an image, not on your phone

The Google Translate application now supports in-image OCR and translation of text: https://support.google.com/translate/answer/6142483?hl=en but this functionality does not seem to be accessible ...
18
votes
4answers
16k views

What is the best way to paste code into a Trello card?

When I try to paste code into Trello I get very weird formatting after saving but it seems it does format code, I just can't get it to work right. Currently I'm just putting links to Gist, but I would ...
0
votes
1answer
38 views

Google sheets: How do you forecast numbers each month in a range that's non-linear?

I've imported a sample of monthly youtube channel viewership figures from google API. I'd like to use the data to forecast what the expected number of views was on each channel for the latest month, ...
8
votes
4answers
3k views

How can I change Google Spreadsheets to have iso 8601 dates as default?

I would love to set my default date-setting to be iso 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date-format for a given spreadsheet by: ...
0
votes
0answers
9 views

Changing permissions on Google Drive file/folder

I was wondering if anyone could help me, I have a script that I would like to create but I am not sure where to start. I would like a script that takes selected files/folders in Google Drive and sets ...
0
votes
0answers
88 views

Spark Mail by Readle not adding accepted calendar invites to my calendar

Anytime I get a calendar invite in spark mail when I accept it will not add it to my Google calendar. It even sends an RSVP to the person that sent me the invite but it won't add it to my calendar. ...
0
votes
1answer
29 views

Copy cell info on account of cell matching specific te

Edited as response to comment: I had to copy data into a new sheet, which is why it doesnt entirely match your answer. Here is where Im at now: attached screendump is new. Hope you can help with ...
1
vote
1answer
9 views

Sort Google Keep “Titles” in alphabetical order

Google Keep "Labels" are sorted automatically in alphabetical order. How do I sort "Titles"in the same way?
0
votes
1answer
28 views

Incorrect and somewhat strange results when using COUNTIFs with Arrayformula

I have three functions responsible for checking if I own a stock (by seeing that the column F is not empty) Then I want to check column AB to see what market the stock is from. In the first case I ...
0
votes
0answers
16 views

Set margins from Gmail settings

I'm trying to set the Gmail margins, but I can't find the option to do that. Which section of the settings should I to look for? EDIT Default settings (I do not want this) Desirable settings Thank ...
0
votes
1answer
14 views

Google Sheets: Formula to get data from other tab

I have a Google Sheet to get an overview of all workshops/events we are hosting. There is a tab INPUT. There is a column for Date, Month, Event, Location, Presenter, Language. The column month is ...
0
votes
3answers
137 views

Checkbox to activate a column in QUERY

Is there a way to activate/deactivate a column in QUERY function? I have a query to query and selection of several columns Select Col1,Col31,Col32,Col33,Col25,Col26, and want to have a checkbox for ...
3
votes
1answer
1k views

Jump to bottom of spreadsheet, blank (non-formula) row

I had a tall spreadsheet that I need to add data at every time it opens. Answers like Go to Bottom Cell have been helpful, but my quirk is that the first column contains formulas that return blank in ...
0
votes
1answer
49 views

How do I share a private video with 170 people

Hi I have a relatively big group (about 170 people), and we want to share videos only within this group (i.e. we do not want people outside of this 170 people group to access these videos). Now here ...
1
vote
1answer
14 views

Can I get a business profile (and so VAT-less invoices - EU) for Google Drive without using G Suite?

We are a very small company and we use Google drive to backup and share our files, we have a 200 GB plans. We are VAT payers and are not based in Ireland but in the EU, so we should get invoices from ...
0
votes
1answer
17 views

Gmail labels - Only archive upon reading the email

I already know how to create a label in Gmail and how to archive the files automatically (remove of inbox). What I want is a way of only archiving the email after I read it. It appears normally in ...
-1
votes
1answer
17 views

Automatically name current version when Google Sheets is opened

I'd like to automatically maintain the original version of a Google Sheets file whenever the file is opened. Manually, this would involve simply opening the file and selecting File/Version History/...

15 30 50 per page