All Questions

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

Added importJSON function and importHTML stopped working

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 ...
-1
votes
0answers
11 views

Browser extension in Firefox/Chromium for getting regex from link text

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 ...
0
votes
2answers
27 views

Conditional formatting custom formula not working in google sheets

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 ...
0
votes
0answers
9 views

How do I lock certain slides in Google Shared Slides?

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 ...
-1
votes
0answers
17 views

Insert data in the next available Row

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 ...
0
votes
0answers
10 views

How to post an aspx web forms and get result

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 ...
0
votes
0answers
14 views

Is there a simple way to play all YouTube videos from My Subscriptions in a random order?

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 ...
0
votes
0answers
16 views

How to get a list of all videos ever uploaded to a YouTube channel

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 ....
0
votes
0answers
18 views

Query Import Range returns two rows

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(...
0
votes
0answers
10 views

Moving Rows of Google Form Responses to a new Sheet based on a specific answer in a column

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 ...
-1
votes
0answers
48 views

Blocking sending an e-mail with an executable attachment FROM A NON-GMAIL ACCOUNT TO A GMAIL ACCOUNT

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 ...
0
votes
0answers
7 views

Google Sheets opening tabs

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.
0
votes
0answers
8 views

Get the date when most people were online on my website, using Google Analytics?

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 ...
0
votes
0answers
10 views

Change entire sheet information based on input of one cell

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 ...
2
votes
1answer
26 views

How to automatically calculate averages from ID in Google Sheet?

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 ...
0
votes
0answers
22 views

Automatically piping the output of a browser's developer tools console in the background

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 ...
0
votes
0answers
47 views

Attackers might be trying to steal your information from accounts.blogger.com

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?
0
votes
1answer
21 views

Possible for users to have unique instances of the same document? (not downloaded copies)

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 ...
0
votes
0answers
40 views

G Suite Collaborative Inbox features from within Gmail

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 ...
0
votes
0answers
17 views

Logic Dependent Check box/Tick box (i.e. a check box that is only usable if criteria are met)

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 ...
-1
votes
0answers
8 views

simple ways to collect/manage simple user input and storage [closed]

noob question: What is a simple way of collecting and managing and also storing simple user input?
0
votes
0answers
8 views

How to regularly backup a database using Amazon RDS?

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 ...
0
votes
1answer
18 views

Copy a Trello board, keep columns and cards, but loose card contents (comments etc)

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..)
0
votes
0answers
6 views

What does Karma do on HackerNews other than allow downvoting?

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. ...
0
votes
0answers
12 views

How to translate aggregate formula from excel to Google Sheet

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))...
0
votes
1answer
64 views

Facebook eliminate country code from phone number and then ask for verification?

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 ...
0
votes
1answer
16 views

How to read a long text in a cell that's a result of a formula?

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 ...
-1
votes
1answer
57 views

How can I speed up this script in google sheets?

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

Google Groups requires posts to select a category from each category group?

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?...
0
votes
2answers
14 views

Convert from duration ( HH-MM-SS) to minutes

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? ...
0
votes
0answers
18 views

How to google-search for one term with any suffix? Are there better search engines?

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 ...
0
votes
2answers
35 views

Is there a shortcut to site:youtube.com (search for videos on Youtube directly from a search bar)?

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 ...
1
vote
0answers
66 views

Once a student log in Admin.google.com, after she log out. All others cannot log in regular gmail

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 ...
1
vote
0answers
4 views

Analytics gets hundreds of users, no hits and no way to filter

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....
-1
votes
0answers
18 views

Display only last 4 character in Google Sheets for privacy

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 ...
1
vote
0answers
4 views

Pandora - list only - no pics

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
3
votes
0answers
24 views

Why are automatic captions on YouTube not available in more languages?

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'...
0
votes
0answers
26 views

Google Sheets automated proper case?

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 ...
0
votes
1answer
13 views

Google Sheets data validation help

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 ...
1
vote
1answer
13 views

I have the formula I want to use but now sure how to change it with time another time zone

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 ...
1
vote
0answers
19 views

Can you permanently change your old name to your new name on YouTube?

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 ...
1
vote
0answers
16 views

How to word count multiple documents?

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 ...
0
votes
0answers
32 views

Why does the react count not add up?

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 ...
0
votes
0answers
62 views

Change page OWNER (not admin) on Facebook

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....
1
vote
1answer
12 views

help with query finding multiple entries in 1 column

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' ...
0
votes
1answer
16 views

Is there a way to conditionally format border styles in Google Sheets?

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)?
0
votes
0answers
44 views

Why do I have to keep having to identify myself when I go into my facebook page

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

Copy conditional formula to separate columns GoogleSheets

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 ...
0
votes
0answers
4 views

MINIFS using multiple ranges

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: =...
0
votes
0answers
10 views

Notification of YouTube video deletion

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 ...

15 30 50 per page