All Questions

6,147 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
-1
votes
1answer
40 views

Can Google Spreadsheets cache images?

I want to create a resource for a browser game and I need to export a ton of character portraits. The url of those portraits is automatically generated with character's id, so you can just load them ...
-1
votes
1answer
17 views

Can I use photos on my personal google drive account for my business website?

Hi I am thinking of images that are used on my website on to the public folder of my google drive account and access it using <img src="some.gdrive.link.com">. Can I use google drive in such way ...
-1
votes
1answer
43 views

how to sign into google mail in one step

I only have gmail, but last week my mail opened with an extra step, by asking me to choose an account. I clicked on the gmail with my name on it, and then the password request came up. How do I ...
-1
votes
2answers
37 views

Mark all line if checkbox is true

I will give an example: I have checkboxes in B3:G3. This is a checklist, I want to change the background color to green for A3:H3 if B3:G3 boxes are checked. Can someone please tell me how to do ...
-1
votes
3answers
18 views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
-1
votes
1answer
34 views

Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet

This would be equivalent to the Excel Worksheet_SelectionChange event.
-1
votes
0answers
32 views

How to record a user's e-mail when they click a button in Google sheets?

I am new to Google sheets and scripting. I've seen samples of scripts here that allows recording of the current user's email when they make an amendment in a sheet. Is there a way for me to click a ...
-1
votes
1answer
37 views

How to categorize/tag cells containing long text according to a list of phrases?

I have cells in a google sheet which have long abstracts. I need to mark/categorize these abstracts in an adjacent column, according to a table of phrases and corresponding tags in another sheet. As ...
-1
votes
2answers
33 views

Query the result of a query in the same cell

I don't know how else to put it of phrase it, I am really stumped here. I will put what I have down below and hopefully, someone will understand what I am getting at. =QUERY(Sheet3!A:B,"select B ...
-1
votes
2answers
17 views

How to archive cell changes in new tab?

I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
-1
votes
1answer
32 views

Google Sheets images

When I insert an image in a cell in Google Sheets from my camera how is that image stored in the cell? I know it creates an image in my phone in a folder called images, but if I want to link that ...
-1
votes
1answer
21 views

Which event can I use to detect remote form submission into sheet?

I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row. Which event can detect that that information was ...
-1
votes
1answer
37 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
-1
votes
2answers
135 views

Strange Event in Google calendar

⏳ПОДТВЕРДИТЕ ПОЛУЧЕНИЕ ДЕНЕЖНОЙ ВЫПЛАТЫ. Уведомление от Центра Безопасных Электронных Платежей. Вам начислена денежная компенсация. Получите денежные средства сегодня ➡ [spam link] This is the event ...
-1
votes
1answer
24 views

How do I find latest invoice number & dates?

Trying to find a formula for the latest date and invoice number. Here is my sheet: https://docs.google.com/spreadsheets/d/1T_rFYDCQhqfrsU9claYPHQTrEz68zpUFKG9HZqqV4Z8/edit?usp=sharing
-1
votes
1answer
101 views

Using SUM in Google Sheets with indirect ranges

I need to use SUM formula to fill the Total formula until next Total comes in Google Sheets like this: Total 6 A 1 B 2 C 3 Total 15 A 9 B 6
-1
votes
1answer
38 views

How to nullify empty output errors in Google Sheets?

I am using the following code in many cells of the sheet, =SPLIT(REGEXREPLACE("" & S2, "(\d)", "$1,"), ",") not all are going to contain data at any one time. How do I stop the empty cell value ...
-1
votes
1answer
15 views

Stop drop-down box errors

So I'm trying to use the drop-down menus to restrict human input, but there is a formula than can fill in those cells with information that I don't want humans to be able to enter in. The formula does ...
-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/...
-1
votes
1answer
18 views

How to display a text after a choice is selected in google form?

So I have my drop down connected to spreadsheet. There are two column which is ID and Name. In my google form, I want the user to select the ID but not the name. The name should be shown according to ...
-1
votes
1answer
82 views

Function OnEdit run slow and timeout error

I have a short timestamp script for my google spreadsheet. But it run quite slow and make a lots function onEdit(e) { var TIMERECIEVE = [0,-29]; var DATETRECIEVE = [0,-28]; var DATEDONE = [0,-...
-1
votes
1answer
460 views

Lost phone contacts after deleting Gmail acount

How can I restore my Gmail account once I've deleted it and it's been almost a month since I deleted from my iPhone 10? I have lost most of my important contacts and no other way to recover
-1
votes
1answer
56 views

How do I copy a friend's Facebook profile picture to Google Contacts?

How do I copy a friend's Facebook profile picture to my Google Contact entry for my friend?
-1
votes
1answer
253 views

Why doesn't google forms recognize responses manually added to the responses sheet

I'm trying to see if I can add responses to a sheet manually through a proprietary application but whatever response I add to the sheets document is pushed down and isn't recorded on the responses ...
-1
votes
1answer
25 views

How to paste a comma separated string into one column in Google Sheets?

For example, if I have (bob, china, bing, bong). I want to put bob on top of china on top of bing on top of bong.
-1
votes
1answer
337 views

How can I use ARRAYFORMULA (or something similar) with GOOGLETRANSLATE?

I'm learning a new language and I recently discovered Google Sheets' GOOGLETRANSLATE function. I thought it'd be neat to have a personal dictionary of translations which I can even annotate. So I ...
-1
votes
1answer
77 views

IMPORTHTML - Can't find specific table on WNBA.com

https://www.wnba.com/stats/team-stats-advanced/#?Season=2018 Is the web page. I can't seem to find the table for advanced team rates or opponent.
-1
votes
1answer
253 views

Unable to link Instagram (business) account to Facebook page

I have an Instagram account and a corresponding Facebook page. For historic reasons they are not linked, but I want them to be now. This is where I fail. On the instagram App I was able to add the FB ...
-1
votes
1answer
32 views

Facebook posts go to Gmail trash bin?

Why do Facebook posts go to Gmail trash bin, whether I read them or not? This causes a massive headache when trying to find important messages in trash bin, among hundreds of items appearing during ...
-1
votes
1answer
11 views

How to replace reference cell and have it affect the main cell if it referencing?

I asked a similar question on the Google Support Forum. I was wondering how I could reference a cell with any sort of value in it to another sheet (inside the same Google Sheets document) and then ...
-1
votes
1answer
39 views

Friends of friends commenting on pictures

I tagged a friend in a picture but it’s now being commented on by people I don’t know. Is there a way to ensure only the intended audience can see it?
-1
votes
1answer
17 views

Odd result in Google Sheets calculation

I am editing an existing spreadsheet in Google Drive and the formula below is giving me an answer I cannot figure out. =if(isBlank({H6}),ifError(1/0),(( ArrayFormula( ROUND((P6*1.2)))-0.05))) where ...
-1
votes
2answers
378 views

Conditionally format cells that not match with range from Sheet2

I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my jira. Now I am trying to compare Column F from sheet1 and sheet2 to confirm if they are ...
-1
votes
1answer
9 views

How to split a cell into key/value rows?

Apple,3,Orange,4,Mango,10 How can I split this cell into key/value rows? Apple (a1), 3(a2) Orange (b1), 4(b2) If I just call split(), I get: Apple 3 Orange 4
-1
votes
1answer
15 views

Outputting a cell x number of times in an array format

Using Google Sheets: Need to display a vertical list, where each occurrence in the A column of sheet1 is repeated based on the number in the B column of sheet1. I've created a dummy file to show what ...
-1
votes
2answers
529 views

I am getting :server IP address could not be found (DNS_PROBE_FINISHED_NXDOMAIN) on new Wordpress site

I'm trying to host a WordPress website on Google Cloud Platform. I purchased the domain from Google Domains. I was getting an Error: Token mismatch error on www.whatsmydns.net. The error has gone, ...
-1
votes
1answer
13 views

How can I search an argument in GSheets to return TRUE if the argument references another cell?

Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is =MROUND((D8 * 2) * Conv!C2, 5) where (D8 * 2) is me calculating ...
-1
votes
1answer
27 views

How to turn checkbox with IF formula?

I have a cell with an "end date" and I have a checkbox under an "Inactive" labelled column. I would like that checkbox to turn on when today's date is after the end date. I can't seem to add a ...
-1
votes
1answer
47 views

Is there a way to backup one's Facebook Page to protect it from hacking?

I know it's a stretch but a family member is being paranoid about her Facebook Page being hacked and deleted. She's partially right because she was the target of a hack recently so now she looks for a ...
-1
votes
1answer
32 views

Does search engines like Google or Bing search through all web pages for a single query every time?

Here is what I imagine would happen when I type in a search query in Google or Bing: The search query is converted into a vector through some pre-trained machine learning models. The vector captures ...
-1
votes
1answer
16 views

Query with Date Selector. Both must be inputted or no information is available?

Currently using: =IFERROR({QUERY(PRI!A4:T,D1,1);QUERY(NON!A5:T,D1,0)},"Nada") This is used to grab information from two spreadsheets with the same number of columns, with PRI grabbing data with ...
-1
votes
1answer
23 views

How to increase formula by increment of 10

I have a spreadsheet with one value per year. I would like to take the average of decades (with, obviously, 10 cells per decade), so I set up a formula along the lines of =AVERAGE(A(1+10):(A(10+10), ...
-1
votes
1answer
22 views

Undo Send - works on some computers but not others. Is Chrome required?

Does it only work with Chrome? Not FireFox!? Undo Send - works on some computers but not others. Is Chrome required?
-1
votes
1answer
53 views

Are Boolean expressions short-circuit evaluated in Google sheet formulas?

Suppose I have the following expression repeated in a long column: =IF(OR($U2=""; COUNT(aHugeRange)=0); ""; SUM(aHugeRange)) I would like to avoid performing COUNT() and SUM() as much as possible to ...
-1
votes
1answer
48 views

Can you resolve Google Docs' comments by email?

In Asana, you can complete a todo by sending a reply to an email about it with the email contents "complete". Can you do something similar to resolve a comment in a Google Doc?
-1
votes
1answer
32 views

Changing the order of a Google Sheets document

I have a Google Sheets document containing names, addresses, birthdates, etc. I need the document to read in order of birth months: January, February, March, etc. How can I do this?
-1
votes
1answer
83 views

How to share free dynamic DNS domain on Facebook?

I'm hosting some websites on my raspberry behing my box and I'm using changeip.com to have a free DNS service... But then, when I would like to post my website's link to facebook or set it as my ...
-1
votes
1answer
60 views

Count worked days per employee

I am creating a spreadsheet in Google Sheets for a client who wants the sheet to pull data from their Google Calendar to calculate how many days each employee works. They use Calendar for their ...
-1
votes
1answer
1k views

Convert phone number format from (404)-313-2974 to 404-313-2974

I have a list of phone numbers entered into Google spreadsheet in this format: (404) 313-2974 How can I convert this entered cell into 404-313-2974?
-1
votes
1answer
56 views

Verify my account

My device has been reset before I got it. I'm being asked to sign in with the Google Account that was previously synced on the device. I don't know the previous email. How do I change the email?

15 30 50 per page