All Questions
6,147
questions with no upvoted or accepted answers
-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?