All Questions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Google Keep "Labels" are sorted automatically in alphabetical order. How do I sort "Titles"in the same way?

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

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

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

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

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

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

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

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

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

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

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