All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

How to archive comments from a YouTube video page for myself?

Looking for a faster way to save comments under a YouTube video rather than manually expanding the page, collapsing the sub-comments and copy paste in some text file.
11
votes
6answers
14k views

Keyboard shortcut to close the ads on YouTube

I am wondering if there is any keyboard shortcut to close the ads (advertisement) on YouTube. For example, as the one as in the picture below.
8
votes
2answers
21k views

Pull CSV data from URL to Google Spreadsheet

I have a site which allows authenticated users (read: in-house users) to download certain data from the site in CSV format, e.g. http://example.com/activities.csv . Can I create a Google Spreadsheet ...
0
votes
0answers
17 views

Embed audio of YouTube video in a web page using <audio> element

Good morning, I would like to take advantage of the possibility given by HTML5 to incorporate audio into a web page. However, it seems that the <source> element should refer to an audio file. ...
1
vote
1answer
44 views

How to remove unwanted email address from list of autocomplete suggestions in Gmail “To” field

I entered user@example.org but accidentally mispelled the address. then Gmail will most likely save the email for future reference. However, when you send your email, an email pops up in your Inbox ...
0
votes
1answer
112 views

Change picture of Google account

I tried to change the picture of my Google account. I did this through Gmail. However, the picture has not yet changed. I tried the things I have read in other related questions; remove/change my own ...
0
votes
1answer
36 views

Email undilivered to one of the receivers. will anyone get the mail?

I sent a mail a few hours ago( suppose to person A and person B) but one of them lets say person A has a system in place such that mails from unknown Id's are blocked but person B doesn't, so person A ...
0
votes
2answers
37 views

How do I open a webpage in Google Docs?

I would like to open this page (with its images) from a URL and edit a copy in Google Docs. The URL does not require authentication. How do I do this? Saving it creates an HTML file plus a folder, ...
2
votes
1answer
1k views

Catch New Rows in Existing Filter Views

I have a series of filter views that filter my Google sheet based on the values in column B. I have 200 rows in my sheet, so the range for each filter view is A1:C200. Often, new rows get added to ...
1
vote
1answer
67 views

Change the country where Google account is managed

Many years ago, I had signed up for a Google Account when I lived in the UK. I have since moved to Germany, and changed my address, country for Google Play and contact telephone number all to Germany (...
0
votes
1answer
68 views

Migrate Google Chats from One Google Account to Another

I have two Google accounts - an old one that I used for a while as a kid, and a new one I opened when I became a working professional and needed a professional-looking personal email address. It's ...
0
votes
0answers
11 views

Xpath wild cards [closed]

Hi I'm trying to use a wild card in my xpath expression to find the Title So far I have this x://a[@title="King"] So far so good it returns the value = King But there are 30 titles on the page ...
0
votes
0answers
16 views

Auto Categorization of Expenses

I am looking for a way to automate the categorization of a running list of expenditures. So in column B I have expenses listed (auto imported directly from financial institutions) and in column C I ...
6
votes
1answer
8k views

Use Twitter Advanced search to find retweets made by a single account?

I've been trying to find a way using Twitter Advanced Search to return retweets made by a certain user. I'm trying to use a 3rd party tool called Twools to pull just retweets using a search. I've ...
1
vote
0answers
15 views

Google Backup and Sync deletes files after syncing them

There's a google drive shared folder that I wish to download on my drive. The shared folder appears on my drive and is too big to be downloaded via a browser (271Go). I use sync to get it on my ...
0
votes
2answers
37 views

Cell reference for contains value in Google Sheet

Looking for help referencing another spreadsheet, where I want to lookup several values in cell A2, to see if the value is contained in the cell (as there are variations), then setup an else clause at ...
0
votes
0answers
3 views

Google Pay card name desktop vs Android

I know that I can assign nickname to a card I have in my Google Pay app on Android. However this name is not shown on the desktop version of the Google Pay - instead it just shows the card issuer (...
1
vote
1answer
46 views

How to Add RTL Tables to a Google Document

As I'm trying to format google doc tables and in reference to this thread I was able to add some formatting to the header row, to the table data and was able to create a doc in a landscape layout. ...
2
votes
1answer
495 views

How to send Google Form results to a particular sheet (“tab”) of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
1
vote
1answer
3k views

Pass cell value into Google script

I'm facing a problem, hope anyone can help me. I have 3 sheets with different functions, data_sheet contains a thousand data with date in descending order in Col A, input_sheet is only for input data ...
1
vote
2answers
3k views

In Google Sheets, how do I input a grading scale?

I have a rubric in sheets. It calculates the grade and turns it into an average in two different cells. I want to take the average cell and use a formula (in the next cell) that would plug in the ...
0
votes
1answer
89 views

Send email notification when a data in column matches a certain value

I am trying to make Google Sheets send a notification to a particular person/s when one of the fields on column Q is equal to the word "High". I want the email to be sent when it is high because it ...
0
votes
0answers
39 views

Script to copy a formula to the next row

I have a script that will capture data from the email and saved it to the next available row in a google sheet. function RevisionHistory() { // Use sheet var ss = SpreadsheetApp....
0
votes
1answer
21 views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...
1
vote
1answer
241 views

Scitpt to duplicate template sheet into new workbook, then rename

I am looking for a script that will create a menu item that will allow me to copy a template sheet that I have created (multiple times) into a new workbook, and rename the copies at the same time. ...
4
votes
4answers
23k views

How to save shared files by Google Drive links in my account

For example someone emails you a link to a shared PDF on Google Drive. Is there a way to add it in your Google Drive instead of downloading and uploading it manually? Also it would be great if the ...
0
votes
1answer
71 views

Comments and Threads in Trello

I am pretty new to Trello and am wondering whether it is possible to improve the looks of the comments under a card. Out of the box, they all run in one thread, which makes it difficult to read, ...
0
votes
0answers
11 views

Is codec used on not intermediate resolution videos in youtube a indicator of quality?

Youtube typically uses for 1080p videos H.264 and VP9. In theory VP9 was expected to be a successor to H.264 but frankly it failed to live to the expectations especially in videos which aren't ...
2
votes
4answers
7k views

Search for seller in Aliexpress

I would like to search for a particular seller in AliExpress. Looks I can do search only by items, but not sellers. Is it possible? And if yes, how can I do it?
1
vote
1answer
10k views

How can I delete my history in Pandora?

I made all these stations over the years, and they are all mixed up and messed up, I want to start over from scratch. How can I delete my history in Pandora?
1
vote
1answer
23k views

Do I have to use my real name to set up a Gmail account

When signing up for a new Gmail account, it asks for your first and last name. Do I have to put in my real name? I have a few other accounts, along with a YouTube account, and every time I login to ...
34
votes
9answers
67k views

How to print a Google Docs document with comments in the margin?

Is there any way to get a Google Docs document to include its comments in the PDF file that it creates when you click the "print" button?
1
vote
1answer
2k views

Can't remove my saved places in Google Maps

I have a bunch of saved places like this one that I can't remove them: After I click on it, doesn't appear as saved (Save button doesn't have the green flag on it) I've tried going to Menu -> Your ...
1
vote
0answers
9 views

Microsoft will Not Let Me Close The Account Without My Phone Number

I am trying to close my Microsoft Account, so I went to How to close your Microsoft account. Then I Clicked Close your account. It asked for my login and password which I provided. Then it shows - ...
0
votes
1answer
32 views

Copy Rows from Master Sheet to other sheets based on user input

I am trying to set up an assignment sheet for my work team. I have a script to move a selected range from one sheet to another, but is there a way to modify it to have the person doing the assigning ...
0
votes
1answer
4k views

How can we find friends or import contacts in Twitter (2019)?

At the moment, my Twitter account only has 24 followers. I plan to increase that by finding and inviting my friends/connections in Gmail or other social networks. It is a very common approach in other ...
0
votes
0answers
7 views

Why do I see youtube ads from channels I have blocked?

I do not pay for the youtube service that blocks ads, so I do not have the expectation of not seeing ads. That said, I expect to stop seeing ads from channels that I have blocked. Since I do not ...
0
votes
0answers
9 views

permit changing a user's display name in a google group?

This has been an outstanding issue for several years and seems like a no-brainer for whoever maintains Google Groups to fix it. Removing and re-adding a group member just to change their display name -...
4
votes
2answers
3k views

How to set Monday as start day of the week in Google Sheets date picker

How to set Monday as start day of the week in Google Sheets date picker? I have changed the locale, changed start day of the week in Google Calendar and can't find a way to solve this.
0
votes
1answer
46 views

How do I import data from one Google spreadsheet to another

I need to import a range of data from one Google spreadsheet to another but I keep getting the error: "Cannot find range or sheet for imported range using this formula" =IMPORTRANGE("https://docs....
0
votes
2answers
21 views

Copy other cells if EITHER column has specific text

In a single sheet wanting to copy D3:N if either B3:B or C3:C = S2. I'm sure there is a simple formula to do this I am just unable to find it!
10
votes
1answer
9k views

Are YouTube likes/dislikes anonymous?

Let's say I watched a YouTube video which I found interesting. I would like to upvote it, but I don't want everyone to know that I watched it. Is there any way for anyone outside YouTube to know that ...
0
votes
2answers
60 views

Check button in Google Spreadsheets specific for each user

I have a Google Spreadsheet with different tasks. I want to implement a check button in the following way: My intention is that the users can't edit the spreadsheet but they have to be able to use ...
0
votes
0answers
18 views

How to protect this Wikipedia page of Taxation in Finland?

I am trying to protect the english wikipedia page about Taxation in Finland. There is the author Watti Renew who tries to delete the table about Finnish income tax of the highest income classes by ...
4
votes
2answers
4k views

How to change default row height of a migrated Google Spreadsheet

The old Google Spreadsheet has a default row height of 17. The new Google Sheets has a default row height of 21. After a spreadsheet is auto-migrated by Google to the new Google Sheets, the original ...
0
votes
1answer
101 views

How to stop Google Docs from accidentally switching user accounts

I have been using Google Docs and Google Sheets for years together with the co-director of our company - switching between her account and my account when needed. Within the last couple of months I've ...
0
votes
0answers
23 views

Chart a graph from data until today

I chart a graph. Data is from Jan to Dec. X axis is dates Y axis is numbers. I want the chart to show only until today without having to keep modifying the chart every single day. Dates are in ...
0
votes
3answers
50 views

Average formula for Google Sheets with substitution over some figures

I have a row of figures from 0 to 2, some cells are empty. I need to count an average for them, but with the rule that would count 2 as 1. Thanks
1
vote
2answers
1k views

How do subtract value in two consecutive rows and print it in a column

I have a situation that needs to be handled. I have values in a column that are values of that particular instance in time I need the difference between each instant. Input and output will be ...
0
votes
1answer
12 views

How to modify my formula to take 1 hour off?

E6 = Finish Time. B6 = Start Time. My working formula: =E6-B6+(E6<B6) =Time worked in Hours/Minutes How should I modify my formula to "minus 1 Hour" for a break? Sounds easy, but I can't get ...

15 30 50 per page