All Questions

1
vote
1answer
2k views

How to create a (recurring) Gmail Calendar Out of Office Event?

I’m going through the Google Calendar API, and I can’t find a way to mark an event as "Out of Office". I work from home every Thursday — and by default in the Gmail Calendar one cannot make OOO ...
0
votes
1answer
3k views

Make cell “flash” onOpen rather than onEdit

I need a Google sheets script which will make the background color of a cell flash. Currently I have a script which works fine, but onEdit. It would be far better in this case if the script could work ...
0
votes
1answer
65 views

Is a shared Google Photos album publicly searchable?

I'd like to share a Google Photos album only with one person and allow them to view and edit the album, but I do NOT want the album or any photos to come up in search results. I saw that the only way ...
-1
votes
2answers
39 views

Change a cell to a colour when a tick box is checked in another cell

I have a cell with a checkbox. I want another cell which contains a date to go green when the tick box is checked. I presume this is done in conditional formatting but I am struggling with it.
2
votes
1answer
871 views

Request for Edit Access using View Access

I have been provided with a link only to View a particular folder. Is it possible for me to request for Edit Access? If so, how can you do that?
-2
votes
0answers
66 views

My restore old google account [on hold]

I already. Have a my old google account. But i. Restore my password. So i can. Revtert my old google account. And all. My ifom
-1
votes
0answers
14 views

Changed Trello password on PC but app still logs in on old [on hold]

I changed the Trello password on my PC When I go the Trello App on my phone - which still has the old password - somehow it is still logging in using that! I thought it might be a cache so I added a ...
9
votes
3answers
5k views

How to customize the toolbar in Google Docs?

Is it still impossible to customize the toolbar with extra buttons? Specifically, I'd like to add the strikethrough one (especially with how horrendous the keystroke for it is), but a general solution ...
6
votes
6answers
23k views

How do I save a photo from an eBay listing?

I wish to reuse a past eBay listing but as it is over 90 days old, eBay will not let me edit it, therefore I want to save the photos from the listings so that I can upload them to a new listing. But ...
10
votes
4answers
7k views

URL for “I'm Feeling Lucky” within specific site

I'm looking for an URL that goes directly to the first Google hit from a certain domain as in "I'm Feeling Lucky" but limited to a certain domain. I'm using this formula, but it typically doesn't ...
0
votes
2answers
7 views

Using IF functions with formatting in Google Sheets

I'm working on a Google Sheet and want to reformat all instances where the number in a cell is "2" and the color of the cell is pink. Is it possible to use information about cell formatting (here, e.g....
8
votes
3answers
10k views

Split-screen display of multiple Gmail inboxes in one account

I just merged my Gmail accounts and am now receiving all the emails in the same inbox while only having to use one account. That's very practical to me right there. Is it possible to split or show ...
1
vote
1answer
9 views

What does the query parameter “sub_confirmation=1” do on a YouTube link?

I recently came across a link to a YouTube video with ?sub_confirmation=1 appended to the link. What does this do?
2
votes
1answer
17 views

IF Cell = True, then retrieve (separate) Cell Value

Cells: T2 = Price to Pay U2 = (Tick box) V2 = =if(U2=True, "Paid", "To Pay") W2 = empty What I want to do is be able to tick U2 and have W2 contain the value of T2. V2 works, so it does not ...
1
vote
1answer
37 views

How to generate all combinations of letters in a word?

Using Google Sheets, how would I show all possible ways to type a word, for example: word Word WOrd WORd WORD wOrd woRd worD without any length word? The given word would go on Row A and the ...
31
votes
2answers
56k views

FILTER(condition OR condition) syntax?

I am using FILTER() to display a value from Sheet 2 where the Name columns match. My problem is where I want: =FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal") as OR results ...
1
vote
1answer
26 views

Automatic merging of duplicate cells under common ID

I have data in column A with IDs and a column B with data for those IDs. Right now I have multiple (usually 2-3) rows with the same ID but different data. What formula to use to merge those into one ...
0
votes
2answers
7k views

How to format the time in this Google Apps Script

I want to format a Google Sheet cell when I read it in my script but it comes out 25 minutes later. The cell's time is 20:00:00 but the output is 20:25. I am using this var formattedDate = Utilities....
4
votes
2answers
25k views

Can Google Forms send emails automatically?

I used Google Forms to create a form for people to register for an event, by entering their name and email address. I would like to set it up so that when a person enters his name and email, the ...
2
votes
1answer
1k views

Can different accounts have the same Gmail address?

I sometimes receive emails sent to my Gmail address but the name that is shown with the address is not mine. I'm not talking about spam, they are real mails sent by real persons and they are as ...
0
votes
0answers
15 views

Google Sheets: Script to Create New Sheets from Template + Rename and Auto-populate with Data from Rows? [on hold]

I have a sheet with many entries from form submissions, each submission with its own row. I have another sheet that is a template to display the data from each submission. I would like to have a ...
0
votes
0answers
4 views

gSheets append values at specific starting cell [migrated]

I have a sheet with data like this, and I want to insert values in A2:C2 using the API. The following code works if there is a value in A1, but if A1 is blank then it inserts at B2:D2. I'm trying to ...
0
votes
1answer
32 views

Delete blank rows from many spreadsheet files and ignore files that don't have blank rows

I created a script to delete blank rows from many spreadsheet files. The script I created like this (Version 1) : function delRow(id, name, startBlankRow, countBlankRow){ SpreadsheetApp.openById(...
1
vote
3answers
2k views

Facebook Error: Failed to create your 3D Photo: Try again or learn more about how to create 3D Photos

I created a stereoscopic 3D photo from scratch using mirrors & depth map generation on an old camera. I've tried various ways to upload it to Facebook. However, I always get errors. How can I ...
0
votes
1answer
28 views

How to output end task time base on start time, duration and working time in Google Sheets

I'm using a spreadsheet to perform calculations and I'd like to make a task management file. For example: Working Time: 8:00 ~ 17:00 Lunch Break: 12:00 ~ 13:00 +- Start Time -+- Duration -+- End ...
0
votes
1answer
14 views

How can I undo deleted comment on YouTube?

I tried to edit a YouTube comment and instead click on delete: After clicking on delete I get a notification that the comment was deleted but I didn't see any undo option: How can I undo delete ...
1
vote
1answer
13 views

I am looking to fetch a table from a website in Google Sheets

I want the first table on this URL https://www.cashbackmonitor.com/cashback-store/amazon/ in my google sheet. When I put this function (below), I can retrieve the first column of the first table e.g....
1
vote
2answers
22 views

Is there a way to force Google Photos to recognize new faces?

I have "Face grouping" enabled in my Google account and I can see around 10 faces successfully tagged when I go to my Albums. However, there's a lot of other people who are not tagged, as well as some ...
-1
votes
0answers
15 views

How can I add a PayPal support/donate button on my opensource project on GitHub in India (Specifically)? [closed]

I am an open source developer from India. I am opening up an open source project on GitHub. I want to set up a PayPal (support/donate/or whatever name is appropriate to put in India) on my GitHub page....
2
votes
2answers
3k views

Edit the Custom Colors for Text Colors in Google Docs

tl;dr the Google Docs color pallete has colors I want and other I do not want. How can I remove some colors? In Google Docs, I cannot change a Custom Text Color. If I select Custom Colors for a Text ...
0
votes
0answers
13 views

automatically export CSV from googlesheet to our server

We have CSV file which is located on our server, https://example/thisFIle.csv. That is the exported data from Google sheet. A third party website is fetching the data from that CSV file every 3 mins. ...
0
votes
0answers
28 views

How to escape the Google Adsense login loop

I am trying to get Google Adsense for my blog. I complete the form and click "Save and Continue" and it goes back to the homepage. I click "sign in" and it asks for my email and... surprise surprise......
0
votes
1answer
32 views

Multiplying a cell value on edit

I am trying to make a functionality that allows me to enter a value into a cell and have that value automatically be multiplied by another cell, overwriting the original entry. For example, if Cell ...
0
votes
2answers
33 views

Expand folders in Google Drive

In Google Drive's folder pane, how do you expand a folder together with all of its subfolders at the same time? In other words, I'm looking for the Google Dive equivalent of macOS's option + right ...
1
vote
0answers
13 views

Updating Multiple Google Calendars With New Schedule

Currently I have 3 Google calendars that I use to keep track of things. I would like to share the information in all three with someone so that they can see my availability (and keep track of that ...
0
votes
1answer
11 views

How to change cell range without deleting it?

In a function, let's say the SUM function, I have a range H25:H37 I want to change this range to H23:H40 using the mouse. The only way I could find is to delete the initial value, then I can drag the ...
0
votes
1answer
7 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
vote
0answers
8k views

Facebook wants my phone number to let me in

All of a sudden I'm unable to access my Facebook profile, I'm asked to provide my phone number to be sent a verification code. I don't want to give Facebook my phone number, but I can't find another ...
-1
votes
0answers
8 views

How can one webpage be opened in multiple chrome windows for screen size testing [migrated]

I have a responsive webpage that I need to test at different resolutions to inspect the layout at these different resolutions. Is there a command line option that I can use to open one webpage in a ...
0
votes
0answers
63 views

Change an entire google sheets to UPPER case, not with an add-on or onEdit(e) [closed]

I need to change all the text in Google Sheets to upper case, the problem is it's filled in by Zapier which doesn't register as an edit for onEdit functions. It's also automatically converted to .xlsx ...
6
votes
1answer
271 views

How to download a public domain Google Books ebook?

Recently, some scans by Google Books, while being in the public domain, are labeled as "Google eBook", for instance all the "digital objects" of a certain BNN series. These books seem very hard to ...
0
votes
1answer
9 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 ...
0
votes
1answer
17 views

Graphing two lines in Google Sheets based on values in first column

I'm trying to create two lines on the same graph, with one being 'Line A' based on Data labeled 'A' and 'Line B' based on B. The X-axis would be the date and would expand over time as more entries ...
1
vote
1answer
14 views

Google Finance Historical Data with Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =...
1
vote
1answer
4k views

How to search within a Twitter user's likes

In Twitter, is there an operator that allows you to search within a user's likes? Perhaps something like likes:username or list:username/likes etc.?
3
votes
1answer
958 views

How do I add guidelines to draw.io?

As options guidelines can be enabled and disabled. There is no option to add guidelines neither help about it.
0
votes
1answer
204 views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0
votes
1answer
18 views

How can I re-enable MFA challenges when I login?

I enabled MFA on my Google account because I wanted to protect it. Every time I logged-in, Google tried to get me to "Don't ask again on this device", and I un-checked the checkbox every single time (...
0
votes
0answers
3 views

Can I split the AdGroup budgets down to specific Ads in Twitter Ads?

If I am running a Twitter Ads campaign and have two ads under one AdGroup, is there any way of splitting the budget for the two ads in the AdGroup? Or does Twitter do this automatically. I know I can ...
-1
votes
0answers
10 views

CURL Post Request to PayPal NVP/SOAP API [closed]

curl POST -d USER=[email] -d PWD=[password] -d SIGNATURE=[signature] -d METHOD=TransactionSearch -d TRANSACTIONCLASS=RECEIVED -d STARTDATE=2019-05-21T05:38:48Z -d ENDDATE=2019-05-22T05:38:48Z -d ...

15 30 50 per page