All Questions

Filter by
Sorted by
Tagged with
-1
votes
1answer
840 views

Whats the deal with foreign websites mirroring YouTube videos and comments 1:1?

Examples: https://azchart.info/ https://trshow.info/ I don't speak the language there, but it is quite obvious the site, or a user on it, is copying YouTube videos, and somehow even the comments are ...
-1
votes
1answer
91 views

Create multiple menu dropdowns based upon 1st rollover, 2nd rollover, 3rd rollover etc

Example: User selects a cell for dropdown. Dropdown shows A,B,C,D,E,F. Upon rollover of B, a new 2nd dropdown populates with RED, BLUE, GREEN, PURPLE. Upon rolling over GREEN, a new dropdown ...
-1
votes
1answer
20 views

How to save a web page as PDF in Computer (I need convert the webpage into PDF with exactly What I see)

I am viewing a docker tutorial. I am running the docker image of https://github.com/dockersamples/101-tutorial in my local. Now when I try to print the webpage using chrome browser then in the print ...
-1
votes
1answer
354 views

How to highlight current row and next row if checkbox is true with conditional formatting (Google Sheets)

Is there a way to apply conditional formatting to an entire Google Sheet so that for every checkbox marked true, it highlights the entire row and the next row? My sheet has a checkbox in every other ...
-1
votes
1answer
42 views

How can I add/ view Google Contact info for email sender within Gmail?

I'd like to be able to view Notes for a particular contact within Gmail. Click on email from or to them. One-Click ADD to Contacts (if not already IN contact) Next time I click on an email from/to ...
-1
votes
1answer
19 views

How can I zoom in when a participant shares their screen on BlueJeans web app?

How can I zoom in when a participant shares their screen on BlueJeans web app? On the BlueJeans desktop program one can double click but that doesn't seem to work with the BlueJeans web app.
-1
votes
1answer
153 views

Google Sheets doesn't load all Images

I often use Google Sheets for illustrating things, but quite often friends and myself can't see all images. This can rarely be fixed by refreshing the page, but very often some pictures are missing. ...
-1
votes
1answer
155 views

How can I edit the details (e.g. change the email address) of a recipient in my Transferwise's account?

How can I edit the details (e.g. change the email address) of a recipient in my Transferwise's account? I can see the option on https://transferwise.com/user/recipients/list:
-1
votes
1answer
550 views

Is it possible to access a Google account using a recovery address without changing the password?

I realized that the password of one of my Google accounts has probably been compromised for more than a year or so. I already changed the password of that account, however I am worried about other ...
-1
votes
1answer
161 views

Custom buttons to trigger the Import or Print in Google Sheets

I am using an HTML function (HtmlService.createHtmlOutput) to show my custom buttons in a popup or sidebar within my google sheets. But I am simply trying to make custom buttons to invoke the already ...
-1
votes
1answer
436 views

Can anyone help me with the script for locking non empty cells in a Range at specified time?

I use this in a very small business. We sale the aggregates E Column and the items(DUST,6MM,10MM,20MM,40MM) and quantity F Column are listed (1 ,2 3, 4, 5,6) in drop down. So the Range E7:F300 are ...
-1
votes
1answer
13 views

Is there a non-coded way to pull last edit user and date into a cell?

Similar to the information as the solution found here. (Is there a quick way to see when a cell in a Google Sheets was last edited?) I would like to populate a cell value with the User who edited the ...
-1
votes
1answer
56 views

Find and replace for the exact value script

I have a little problem with my Google Apps Script, which I found on the Internet. If I want to replace "05" with "98", all numbers that contain "5" will be replaced ... such as. "35, 55, 15" etc. ...
-1
votes
1answer
363 views

Google Sheets Script Clear cell on Sheet A after value submitted via form to Sheet B

NOTICE - I am a bit of a noob when it comes to writing scripts. I do lots of google searching, cutting, pasting, modification, researching etc. I haven't been able to find what I need for this ...
-1
votes
1answer
145 views

Using “IF” or “Query” statement paired with “ImportRange” to bring in data set from one sheet to another

I have a sheet where I input my jobs booked. I want to be able to import information for the first 4 columns (Job Number, Job Name, Salesman, Date booked) if Column F (Permit Required) has a "Yes" in ...
-1
votes
1answer
44 views

Google Sheets - Looking for script that auto capitalizes all cells in a specified column

Looking around, I found different things, but I never found the spot where you could specify the range, and I'm not familiar with this script. Can someone please show me a script for this? For ...
-1
votes
1answer
24 views

How to get the text from the Other field in a google forms question to be used in the visualization?

On a check all that apply (checkbox type) question, some respondents used the options I created and othere people used the other box. The issue is that for the people who used the other box, the data ...
-1
votes
1answer
1k views

Unzip file in Google Drive using colab?

I tried using the command: from google.colab import drive drive.mount('/gdrive/') !unzip -uq "/gdrive/My Drive/File.zip" -d "/gdrive/My Drive/File/" This worked out for small file like a zipped ...
-1
votes
1answer
305 views

Variable in the google document

I have a large google document I'm working on. There is the same text there that used in many places. It is changed sometimes as the document evolves. I'd like to have some way to change it ...
-1
votes
1answer
896 views

Sheets: Condense a column with empty cells

I have a Google Sheet with multiple columns and some of the columns have empty cells at arbitrary locations. I want to 'condense' the columns, that is, simply shift upwards all cells in the column so ...
-1
votes
1answer
15 views

High quality spell checker which works **online**

Grammarly is a great spell checker. Unfortunately the have no simple way to check text online (without chrome extension) Is there a high quality spell checker which works online? I would even pay ...
-1
votes
1answer
16 views

I'm looking for help with a formula to automatically update 10 previous days on a frequency count

I'm working in behavioral analysis and trying to implement a formula the would track and automatically update the number of behaviors per time period. We track the 10 previous days, which gives us ...
-1
votes
1answer
37 views

EXCEL: If cell x exists in column A then print row 2

I'm currently looking at a set of data like this: What I want is: If I enter something into G22 that exists in row A I want G25-G35 to show the content of 2A-2K respectively, else say blabla. I have ...
-1
votes
1answer
35 views

if cell B4=B1:B2, countif C1:E2=AAA

If have 2 tables. I need the count of AAA for a particular name in Table 2. Example: I need to count the number of times AAA occurs for Peter.
-1
votes
1answer
20 views

Pulling data from most recent google sheet

I am currently working on a sales sheet for my team and have a question. I currently have each month separated into different sheets for ease of use with our current workflow and would like to be ...
-1
votes
1answer
221 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.
-1
votes
1answer
171 views

Help with Google Script Editor and checking the value of all cells in a certain range

I am using google sheets to record our printer cartridge inventory, and using script editor to check the cells C2:C50, and send out an alert email if one cell falls below 1 after editing. I finally ...
-1
votes
1answer
42 views

Google Drive: Copy template document to folder via contextual menu

We use Google Drive to store our team's documents in the cloud. Some of those documents include templates that we use repeatedly in multiple client files. Currently, we either make a copy from File >...
-1
votes
1answer
44 views

Google Sheets: How to highlight the minimum value in a discontinuous range?

Here is a sample of my spreadsheet: I'd like to highlight with bold the earliest date in the yellow / red / blue ranges, without taking into account cells of the other two colours.
-1
votes
1answer
110 views

Why Instagram show “Message” button just in Chrome?

"Message" shows up in just Chrome. You can't see it on Chrome Safe Mode, Edge, or Firefox. I clicked "..." but not there.
-1
votes
2answers
114 views

Is there a way to automate a priority table in Google Sheets based on another table?

I have a shared sheet where I have people list their classes by priority like below: StudentA StudentB StudentC StudentD Math Math Sci Eng Sci Eng Eng Math Eng ...
-1
votes
2answers
2k views

How to download videos from YouTube to Google Drive [closed]

I am looking for a webapp which can download videos from YouTube to Google Drive. I am preferring pure webapp not browser extension based solutions, because primarily I will use that webapp in mobile ...
-1
votes
1answer
952 views

Get email address in from Google Forms in script

I'm creating a Google Form where guests can log in and an email will be automatically be sent to the person that submits their form. They are not required to log into Google as this will be running on ...
-1
votes
1answer
28 views

Boss asked me to create a spinnable image in a website, but . .

. . . I'm not a programmer, although I do have a basic knowledge of programming and have passed one college course in it. Here is what I am being asked to do. I created this 3d model for my job in ...
-1
votes
1answer
2k views

Google Sheets ImportXML //div[@class= is not working

I am trying to scrape the div "tech-name" from this website https://www.whatruns.com/website/bestbuy.com with the following formula =index(importxml("https://www.whatruns.com/website/bestbuy.com","/...
-1
votes
1answer
23 views

Extracting Titles to Sheets By Scraping

I am trying to write a formula that will scrape all of the titles of products from this page: https://www.1stdibs.com/fashion/ what am I doing wrong? =ARRAYFORMULA(REGEXEXTRACT(QUERY(ARRAY_CONSTRAIN(...
-1
votes
1answer
34 views

Is it possible to acheive this in google sheets?

I want to implement the following in google sheets, but I don't know how to or if it is even possible I have a sheet, let's call it "products", in which every entry has an ID tag and a value I want ...
-1
votes
1answer
2k views

Google Drive PDF - How to Go To Specific Page in PDF Opened In Chrome

Expected Quickly go to specific page in a PDF opened in Google Drive with a Chrome based browser. i.e. In Mac's Preview app on desktop, Go > Go to Page... allows the user to go to a specific page. ...
-1
votes
1answer
188 views

Instagram screenshot detection

How can I know if there is a way to be notified if someone screenshots an Instagram user's Posts/messages etc? I believe currently Instagram advises users if someone screenshot the images and videos ...
-1
votes
1answer
22 views

Google Sheets calendar script is timing out

function onEdit(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if(sheet.getName() != "Sheet2") { return; } var lastColoum = sheet....
-1
votes
1answer
180 views

Fix my script? How can I automatically create events in google calendar using dates from google sheets?

I read that it is possible to link a google sheet to google calendar, so dates can be used to create events in the calendar. I used script I found around about, but absolutely nothing happens. Can ...
-1
votes
1answer
353 views

I want to create a Google account but I don't want to use my real name

I want a Google account, but the thing is I'm a private person, I don't want to share My first and last name. Just for an account. So my question is, can I use a nickname when creating an account?
-1
votes
1answer
491 views

Google form where all answer options calculate to 100%?

Put the % of how much you spend of your salary in the following categories: [Airtravel, Rail transport, Taxi, Personal car, Uber ...., Other] I want to format the question in Google Forms such that: ...
-1
votes
1answer
153 views

Software that would convert Google documents to .docx

Is there a way to convert a Document that you create in Google Docs to .docx or .odt? Edit: To be more specific, I am looking for a software that would be able to archive this.
-1
votes
1answer
23 views

Deleting old/unwanted files

If I no longer in need of a shared document that I do not own, can I delete it without bothering anyone else’s (owners included)
-1
votes
1answer
28 views

No logger output in sheets

I am getting no output from the logger in sheets. I am a boob, although a 30+ year programmer. Here is my function: function onChange(e) { var spreadsheet = e.source; var cell = spreadsheet....
-1
votes
1answer
158 views

Web App get url not working from IMPORTXML

My goal is to get data into my spreadsheet from my script that mimicks the way IMPORTXML works. I want to return html from my script and consume it with IMPORTXML. It's disabled now, but at the time ...
-1
votes
1answer
945 views

How to add Print buttom in a sheet to print other sheet

I need a script to, adding a print button in a sheet1, to print the entire sheet2. How can I do this? Many thanks
-1
votes
1answer
50 views

ImportRange and Query Function Data is condensing into one cell

I am trying to create a spreadsheet that imports data from one spreadsheet into another and then sorts that data by a key phrase. Here is the formula I am using: =Query(Importrange("URL","...
-1
votes
1answer
582 views

How to set Google Group so anyone on the web can send us an email?

I've been trying to find an option where I can set google group as a public so anyone on the web can send us an email. Apparently, this is what we have as an http://prntscr.com/q9yy0l Appreciate all ...

15 30 50 per page
1
608 609
610
611 612
629