All Questions

Filter by
Sorted by
Tagged with
-1
votes
0answers
684 views

Facebook account verification without mobile number

Facebook didn't recognize the device I logged in from and now wants me to verify my account with my phone number. I don't want to do that. Can I do the verification or get around this without a ...
-1
votes
1answer
41 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
31 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
17 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
15 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
32 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
46 views

Friends' post not showing in my newsfeed

My daughter and I are friends yet unless she changes her posts to public I cannot see them. She has an iPhone and I have an Android. I have her on see first and she has not blocked me. How can I get ...
-1
votes
1answer
30 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
0answers
28 views

Cannot remove notification stating that update to my profile needed

I cannot snooze my notifications about "Need to update personal info". When I open a dialog, click "Skip", and then "Go back to my profile", the notification icon is still displayed. I even tried to ...
-1
votes
2answers
31 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
15 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
26 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
20 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
2answers
124 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
0answers
12 views

Unhide event in private group

I am a member of a private group. Another member created an event for the group. I inadvertently clicked "Hide Event" in the events tab. Back on the main group page, I can scroll down to the ...
-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
16 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
66 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
414 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
51 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
50 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
202 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
21 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
281 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
2answers
2k views

Disable automatically calculation on a single sheet in Google Sheets [duplicate]

I would like to disable automatic calculation on a single Google sheet and then have a trigger, either by button or through some implementation of scripts, inserting a column, etc that will allow me ...
-1
votes
1answer
73 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
210 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
2answers
82 views

Google form wrongly delete rows in second sheet

I copied a previous question here since it's exactly the same as what I want to ask: I created a form in Google Docs. Then I created a second sheet to pick and process data from the first sheet ...
-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
2answers
24 views

How can I group by one column to join values in multiple rows?

Let's say I have a survey of people in teams, and what fruits they like: User | Team | Fruits ---------------------- Dave | Mine | Banana, Apple Steve | Mine | Apple, Orange Matt | Yours | ...
-1
votes
1answer
38 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
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
471 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
31 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
45 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
47 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
68 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
54 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 ...

15 30 50 per page