All Questions

Filter by
Sorted by
Tagged with
-1
votes
1answer
45 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
1answer
40 views

Gmail error message disappeared before I could read it

I clicked "send" on a message in Gmail, and one of those black error message/info boxes popped up in the lower-left corner. I wasn't expecting it, and the length of error text was somewhat substantial,...
-1
votes
2answers
77 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
30 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
23 views

What is the bot in Facebook for Developers' Object Debugger? [closed]

Do you know what bot that read websites' metadata from Facebook for Developers' Object Debugger? Perhaps the name is shown in wireshark, but since I have no root access to any server, I'm unable to ...
-1
votes
1answer
101 views

Sequential numbers via formula - Google sheets - IF & MAX

I use this formula to find highest value in column A of other sheet, and then add 1 to it to get new unique number for a record ID, and I use... =if(B3<>"",max(Backend!A3:A)+1,) with this ...
-1
votes
1answer
182 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
1answer
209 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
133 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
1answer
187 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
-1
votes
2answers
49 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
2answers
49 views

Help with a Vlookup function to return multiple results of not exact match

I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
-1
votes
1answer
21 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
-1
votes
1answer
109 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
29 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
157 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
193 views

Strange Event in Google calendar

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

Page headers for sections in a Google doc

I want to use different page headers for each section of a Google doc. When I edit a page header, the Options menu offers Whole document, This section, and From this point forward. No matter which I ...
-1
votes
1answer
424 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
152 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
2answers
162 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...
-1
votes
1answer
117 views

Trying to fetch data from shopback.com.au with ImportXML function in google sheet

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
-1
votes
1answer
272 views

Google Sheet Query returns first 3 rows in one row

I have made a simple query that combines data from 4 separate sheets: =query({'1.MA'!A13:O200;'2.PF'!A13:O200;'3.BM'!A13:O200;'4.C'!A13:O200},"Select * where Col2 is not null ") The objective is to ...
-1
votes
1answer
90 views

Does the Google Adsense underage policy apply if operated by an adult?

Is it allowed to use Google Adsense underage, if an adult creates and manages the account? Using the adult's email is not an option, it must be the underage one. The adult's bank account can be used ...
-1
votes
1answer
18 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
2answers
2k 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 (...
-1
votes
2answers
421 views

Cannot find archive in Gmail even when looking in All Mail

I seem to have tried everything suggested in answers to this same question. Today, June 13th, 2019, I accidentally moved some messages into the archive, and I know I've done the same thing in the ...
-1
votes
1answer
64 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
74 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
2answers
150 views

optimize onEdit managing set of many checkboxes

I have onEdit script that hides or shows rows by checking/unchecking checkboxes (yes/no values). Looks like this if(orpscscchbx.getValue() == 'no') { var rowsHided = 0; for (var i = 0; i ...
-1
votes
1answer
321 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
26 views

How to get back to manager level in Team Drive I created?

I created a Google Team Drive and automatically became a manager. Then I lowered down my level to content manager. I realized that I can't add or delete members since I lost my qualification as a ...
-1
votes
1answer
573 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
72 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
13 views

How do I upload a video from my iPhone to Dropbox?

I have a video and want to upload it to Dropbox to send it to someone. How do I do that?
-1
votes
1answer
334 views

Ampersand causing issues in Google Sheets Formula

I was trying to use the hyperlink formula to create an automatic e-mail creation, however, when i try to pull an information that has Ampersand in it the formula doesn't end. Note that the formula ...
-1
votes
1answer
346 views

Sending pdf with Google sheet email

Trying to send a pdf attachment to an email using Google sheets. I have checked and tried to use the replies in previous responses but my code fails after sending the first email. This is the code I ...
-1
votes
1answer
213 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
419 views

Running script to replace “null” with nothing in Google Sheets

I tried to do this through a macro but I'm unable to have it actually record. I'm not a coder so I've been recording macros and using the code from there to create an add on. I need a script that can ...
-1
votes
1answer
35 views

Recent Google Docs gone after uninstalling & reinstalling the app

I uninstalled Google Docs on my android phone yesterday evening to make space for updating WhatsApp, then reinstalled Google Docs half an hour later. Didn't think anything of it as it all backs up ...
-1
votes
1answer
108 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
2k 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
113 views

Can't get Penn Foster to work on anything but Chrome, want to use on Firefox

I want it to work on Firefox or even CHROMIUM, but whenever I try to read an article for school, it refreshes over and over until it logs me out. It shows me the article in between refreshes. Is there ...
-1
votes
1answer
50 views

How to automatically add new row in Google Spreadsheets

I want to automatically add row in Google Spreadsheets when I type information in row 5 by Google script. ]1
-1
votes
2answers
2k views

Applying IMPORTRANGE formula in Google Sheets between tabs

I have one Google sheet having three tabs, Sheet 1, Sheet 2, Sheet 3. I have another tab having the name "Sheet 4" in which I want to import all data from these three tabs, but the problem is data in ...
-1
votes
1answer
29 views

Update giveaway quantities in Google forms

I am in charge of giving away a number of T-shirts which come in different sizes and colors, but they are limited in quantity. I wanted to create a Google Form for giving the T-shirts away, but I do ...
-1
votes
1answer
524 views

How do I install Spreadsheet Freezer?

I have hear that Spreadsheet Freezer could help me to control when a formula is recalculated. I read on the it's site that I could find the install link here, but I only found questions that point ...
-1
votes
1answer
32 views

Auto refresh screens of my friends

Every 5 min I am uploading a file on Google Drive using backup and synchronize option. Let's say the file name is stockchart.jpg image file Now I am sharing this file with my 25 friends every day. ...
-1
votes
1answer
27 views

Why did my emails from a listserv stop threading?

I am part of a listserv that until late March, threaded messages from the same conversation. After late March, each reply to the same conversation comes in as a separate message. What can I do to fix ...

15 30 50 per page
1
603 604
605
606 607
623