All Questions

I built a great Google Sheets spreadsheet which has been working for a year with no hickups. It pulls data from websites using importHTML. I then tried to add the importJSON function to the ...

I am wondering if Firefox or Chromium supports or has an add-on that allows you to define a regex in the config and when enabled, there will be something like a right-click option on links to "Copy ...

custom formula is: "=COUNTIF($B1:$B100,"month")>1." I tried also: "=COUNTIF($B1:$B100,"month")>1" =COUNTIF($B1:$B100,"month")>1 ="COUNTIF($B1:$B100,"month")>1" I know it shouldn't work ...

I am working in a group on a shared Google slide project for class and I need to know how can I lock and protect ONLY MY SLIDES so that other members of my group cannot make ANY changes to them ...

i'm currently working on a google sheet where I want to use a prompt to enter data. However I'm having difficulty finding a script that will populate the entries on the next empty row on a certain ...

There is a asp.net web page, aspx, Search By Address, which works fine in the browser, and I can inspect the request in Chrome debugger, but instead of doing this search manually, I'd like to do it ...

Alternatively, is there a (simple) way to randomize all videos in a given channel or get a single random one from all videos, not just from some recent ones? Native YouTube shuffle feature seems not ...

How can I get a list of all the videos ever uploaded to a channel? I need a list of titles in a format that allows me to easily search a particular element through them. Best thing would be a simple ....

I've been using =Query(Importrange( functions for quite a while now and something I can't figure out is why the import is returning with two rows. Here's the formula I've been using: =QUERY(...

I have a Google Sheet collecting responses from a Google Form. Based on answers in Column C (Col3), I would like the entire row imported to a completely different Google Sheet. I figured out a ...

I am a small private software developer wanting to sent (using a non-gmail account) an executable file as an attachment to a recipient having a gmail account. I have created the executable which is ...

We have set up a google sheet that has each month with a different tab, we want to open the current month, what is the simplest solution as the main user is not very computer literate.

I am trying to find out where in Google Analytics I can see the "peak" of "active users" online on my site. The realtime report gives me: In the screenshot it says 368. But where can I find the ...

I'm trying to create a function on a secondary sheet to monitor which of my blogs are getting the most traffic. Currently my secondary sheet has a formula that works to show me blogs that have over ...

I've been looking around for an answer but couldn't find what I was looking for. The problem is that I want to use an arrayformula, but can't figure out a dynamic formula that: Looks at the unique ...

essentially a requisite of utilizing the computer algebra software I am proficient in to perform analysis on data I collect in other programs is that said data is collected in a text or csv file ...

Occasionally Google askes me to re-authenticate myself. And I get the screen below after entering my password. Anyone else getting this too? Why is this happening?

My Google sheet consists of a locked list of items and a single cell that can be edited. This cell acts as a search box to filter the list. I want multiple users to be able to search at the same ...

Hullo! I think G Suite/Google Group's Collaborative Inbox offers some features that would be great for my organization. But I also think the fact that there is a user portal that is separate from ...

Simply, I would like to have a column of tick boxes/check boxes that can only be ticked if another column has a corresponding true value. I thought perhaps custom data validation would be the way to ...

noob question: What is a simple way of collecting and managing and also storing simple user input?

We created a database using Amazon RDS and now we would like to take regular (nightly) backups of this database using RDS. How can we do so on RDS? What are the steps for doing so using the AWS ...

Is it possible to copy a Trello board, keep all the columns and cards, but loose all the card contents (eg. comments, descriptions, checklists etc..)

On Hacker News, you accrue "Karma"/reputation points as your posts are up-voted (and lose points if they are down-voted). Once you have 500 Karma points, you earn the privilege of down-voting posts. ...

I am kinda struggling now. I need to make this formula from excel works in Google Sheet. =INDEX($C$5:$C$24,AGGREGATE(15,3,($B$5:$B$24=$M$8)/($B$5:$B$24=$M$8)*(ROW($B$5:$B$24)-ROW($B$4)),ROWS($A$5:A5))...

Basically, facebook suddenly asks for verification. However, they eliminate the country code from the verification. One obvious explanation is that the guy do not put the country code in his phone ...

I have a text cell that needs to in the "Clipping" wrap mode, cutting most of it away from view. Or is at the end of the range. Or is too long to be displayed. Normally, I would read the cell by ...

I am wondering if there is a more efficient way to speeding up this script? var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Trends"); var wsOptions = SpreadsheetApp....

Let's say I have the categories below: General Discussion Art Music Unrelated Memes When I create a new post, it REQUIRES me to choose one category from each group. Is this behavior configurable?...

I want to convert from duration ( HH-MM-SS) to minutes, but the result return only correct when duration of hour < 24 hour with function HOUR(). Otherwise result is not correct. Anyone can help? ...

I am trying to find German laws about occupation. The German word for "occupation" occurs as "besatz..." with any possible ending. I tried adding {*} behind the root term {besatz}. But searching with ...

I use different search engines and anytime I need to search specifically on google all I need to do is type !g Is there a shortcut for Youtube as well because typing site:youtube.com takes too much ...

Once a student log in Admin.google.com, after she log out. All others cannot log in regular gmail. Web error message "admin.google.com is for G Suite accounts only. Regular Gmail accounts cannot be ...

For the past week my GA has been getting random jumps of hundreds of 'active users' on my account, with 0 data to go with them. I get no new page hits, location data, events, or other data, just users....

Display only last 4 character in Google Sheets Current situation: I have a scanner which will scan customer id. The id number will be in google sheet. However, on scanning I do not want google sheet ...

Pandora music streaming. Showing "My Collection" displays album pics. This is really annoying because it takes up so much screen real estate. How do I get only a textual listing? Thank you

The official documentation says "Automatic captions are available in English, Dutch, French, German, Italian, Japanese, Korean, Portuguese, Russian, and Spanish." Is there a reason why YouTube doesn'...

I'm playing the game World of Warcraft and my guild has an attendance signup sheet for raids we do every week together. Everyone visits the sheet and types in their class|name|talents so that the rest ...

I am trying to do this simple thing in Google Sheets with data validation, so what I want to do is not allow people to put negative numbers and numbers with decimals. I've been trying a lot of ...

I have a formula setup that I want to use. But I have a separate sheet that I want to use in a different time zone. The one I have written is in EST. but I want another sheet to use the same formula ...

So I have a YouTube channel and my family members found out and told EVERYONE i know so i changed my name and my family members typed my old name and my new channel name popped up so is there any way ...

I have a Google Drive folder containing dozens of Google Docs. Is there a way to run a word count on a selection of files (or all of the folder contents), and read either a sum of the counted words ...

On Facebook it is possible to view a count of each type of reaction. Thus a post may say 6 reactions which may further be drilled into as 5 Likes, and 1 Angry. Yet the list of persons who liked the ...

A former employee had designated herself as the page OWNER of our company Facebook page. I'm still listed as an admin, as is one other person, but I can't remove this former employee as the page owner....

I am trying to query several different colors from one column. This is what I have so far: =query('Raw Data'!C1:J1000, "Select E, D, I, J, C, F, H where H contains 'Monday' and F='Green' ...

The title says it all. I have some conditional formatting rules, it seems I'm limited to some basic formatting options; Is there any workaround to apply further formatting options (such as border)?

Why can't I get into my facebook page? They keep asking to identify myself everytime. I have never had to do this.

I've got a simple conditional formula to make cell green if there is more than X not empty fields. It works fine but I need a way to copy that formula to other columns. When I do it the simply click ...

I am trying to find the smallest positive value for multiple ranges. Essentially I want to find it in column J without including cells J7,J14,J21,J28 and J35. This is what I have so far: =...

How can I get notified when a YouTube channel unlists/deletes a video? (Immediately is not necessary.) There are services that monitor website changes, but a YouTube page is too dynamic (full list of ...