All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
157 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
14 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
6 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....
0
votes
0answers
6 views

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 ...
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
7 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
10 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
3 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
5 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
14 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
1answer
5 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", C2*8, ...
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
81 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
10 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
15 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
567 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
44 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
7 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 ...
13
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
7 views

How can I get to the bottom of a Google Sheet

I want to open my Google Sheets and go automatically to the bottom/last line entered as there are over 2000 lines. I have entered the below text in: tools > script editor, as seen in another post ...
0
votes
0answers
82 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
28 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
27 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
136 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
0answers
7 views

Stacking Events - Google Calender

I'm a college student who uses Google Calendar to plan my week out (with ADHD, I basically use my phone to fill the executive functioning void in my brain) I have my classes and office hours logged ...
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
13 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
15 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/...
0
votes
1answer
18 views

Assigning rank in another sheet based on Average

I have a list of names with an average beside it for every day Monday-Friday. A subgroup of names within this list will be highlighted. I want a macro to assign ranks of the highlighted individuals ...

15 30 50 per page