All Questions

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

Conditional Formatting on Google Sheets using regex

I am now going in circles, I tried to look for answers here but I am still stuck. I want to highlight a cell using conditional formatting if the value of that cell is present anywhere in a specific ...
0
votes
1answer
11 views

How to copy range from one sheet to another column with offset

I have a range of data on sheet5 which needs to be copied and inserted 27 columns in from the end of sheet1. I can get it to insert the column in the right place but it doesn't copy the data. I am new ...
0
votes
0answers
15 views

How to delete all my replies on YouTube

I understand how to delete my YouTube comments, but is there a way to bulk delete all the replies I have made at all video sites without having to return to each individual site?
0
votes
0answers
20 views

If cell contains certain text then another cell calculates a number

I have a budget spreadsheet with two sheets. First sheet is titled "Summary" and the second "Transactions," where I log financial transactions. I want a cell (Q18) from my first sheet to return the ...
0
votes
0answers
13 views

Google Sheets: auto-fill with increment to filled cells

So basically, what I'm trying to do in Google Sheets, is: I have a column called 'Name' and a column called 'Badge number'. Badge number consists of 2 parts: category and increment number. For ...
1
vote
0answers
11 views

How can I avoid Google's redirection notice, when feeling lucky?

Since a few months, Google's previous "I'm feeling lucky" URLs, e.g., http://www.google.com/search?q=stackoverflow&btnI (taken from this answer), have all begun pointing to "Redirection ...
0
votes
0answers
6 views

Copy ads from one account to another dynamically

I manage about 35 Google Ads accounts under an MCC account. We have set up a child account designed to contain all active ads contained in the other child accounts. I'm looking to create a script that ...
0
votes
0answers
10 views

stock optimization using covariance matrix using Markowitz theory

I'm trying to use a template to see what it says about my stock portfolio. It uses a covariance matrix with the data from excess returns. The template instructions say to use an add-on to calculate ...
0
votes
0answers
7 views

Does a GitHub export provide commit history?

(Via settings | account | export account data) Does it download all commit history for all your repos? Or just a snapshot of HEAD?
0
votes
0answers
49 views

Can an employer filter incoming emails on GSuite (business email)?

With Google Suite for business emails, can an employer create a situation where I can receive normal work emails without issues, but then make it seem like an email that was sent last night was ...
0
votes
0answers
9 views

Data range chart for form submission

I want to make a chart from a Google Form submission. Depending on the score I want the person's name to show up in a specific column.
0
votes
1answer
18 views

Sheets - Determine Cell Number with Equation

I'm trying to reference a cell by the following equation: =A(51-(48-(COUNTIF(Info!A5:A52,"*")))) A51 is the last possible cell that information could be in (hence the 51). 48 is the total number of ...
0
votes
0answers
12 views

How to setup Google Sheet to import data to a new row when requirements are met?

So I have a Google Sheet I've made at work to simplify our needs for receiving product, the old sheet was a template and people handwrote everything which leads to confusion for people putting the ...
-1
votes
0answers
49 views

How can I know what sites or places I have used my Gmail at?

I am having problems with my Gmail and its not letting me add funds to it to buy stuff in Google Play Store. So I am thinking about deleting it and creating a new one, but before I do that I want to ...
0
votes
1answer
26 views

If then with a checkbox

I have a Google Sheet. I am trying to do an if then statment. If cell C8=True then I want it to perform a function. I know this is not right but wanted to give you guys example of what I am writing ...
0
votes
0answers
11 views

How to use Apple Mail App instead of Gmail when mailing an event from Apple Calendar app

I am using Apple Calendar App (with Google Calendar data). I am used to "mail event" to share them with someone (not to invite them, just to let them know of an event). When doing so, Calendar App ...
1
vote
1answer
35 views

How to query on a Google Sheets to sort by month

I'm using this Sheetgo Attendance template on Google Sheets, but it's designed for US Schools so it's needed to sort by January to December. I will provide below the assets that I've have about it. ...
0
votes
1answer
24 views

I don't want warnings of Gmail ‘unusual sign-in location or device detected’ and I want to stop people attempting to sign in being blocked

I have a website about prisoners-of-war. People who had relatives who were POWs email me with details of their relatives and any queries they have, and I put the details on the website and try to help ...
0
votes
0answers
3 views

Sorting by week in google sheets Analytics add on

I just want to run a simple weekly traffic report with the Google Analytics Sheets add on. It does work fine, but I can't seem to figure out how to sort the weeks in chronological order with the jump ...
0
votes
0answers
25 views

Are certain keywords in Instagram handles banned?

Is the word "thot" banned in Instagram handles? I'm trying to get a specific handle and have noticed that I can't seem to get anything with thot in it. Same with "penis" and "cunt", but other words ...
0
votes
1answer
15 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 ...
0
votes
0answers
20 views

Print First Modified TimeStamp of edited Cell in a Column range [duplicate]

This code by @Ruben prints out the timestamp for the first modification for A1 into B1. How to do the same but for the whole column so A2:A printing results into B2:B? // Global variables var origin =...
0
votes
0answers
13 views

My function links all required cells between google sheets except one!

I have this query =query(IMPORTRANGE("<https://docs.google.com/spreadsheets/d/1uxIkcjOTxFAd25Ukzji3VJKoFbAKybuFXfHlBzaGDWc/edit#gid=1385200762>","Master!A3:y"),"select Col2, Col3, Col12, Col13"...
0
votes
1answer
14 views

Variables in Google getRange

I have a simple need to copy a range (E4:G4) and paste it X rows below, determined by the value of a cell, C2. I think I may be misunderstanding the offset function since when I run the routine, I get ...
0
votes
0answers
10 views

Manage autofill contacts in Gmail

This started as how do I delete an incorrect email address which is stored in the autofill list in gmail. I searched for help on this site which indicated I can do this through managing contacts. ...
0
votes
0answers
4 views

SourceForge: How to determine which subscribed tickets have new content

On SourceForge, besides checking email, how does one determine which subscribed tickets have new content? For example, I posted a bug report ticket on a SourceForge project. The developer of that ...
0
votes
0answers
16 views

Output word within a string of words, if it matches to a value within a named range

I have a list of search queries for cars like: hyundai ioniq hybrid rav4 hybrid hyundai ioniq electric toyota yaris petrol vauxhall automatic car I also have a list of models of the cars (ioniq, ...
0
votes
0answers
8 views

Trying to send request after unblocking someone

-My girlfriend blocked and unblocked me a couple of times and now she can't send a friend request anymore what must she do?
0
votes
0answers
41 views

Gmail property password update

I have email accounts in Google Mail that I can't access property settings on and I nead to update password for these accounts which have stopped working. How do I do this?
1
vote
1answer
16 views

Sum depending on value of Column B and Date in Column C

Column A: Name Column B: Date (mm/dd/yy) Column C: Value I want to sum column C every time column A is a specific name & the corresponding date is before 2020 Small sample/Example of what I'm ...
0
votes
0answers
6 views

Double clicking on an ics file to add to my google calendar?

It's been a decade since this question has been posed here and the answers there have been outdated for nearly that long. There is absolutely no reason why it should be difficult to configure double ...
0
votes
1answer
8 views

How to convert datetime string to datetime value in Google Sheets?

Let's say cells A1 and A2 have these values: 13 Jan, 02:21 am 12 Jan, 10:15 pm And many more values like those below in that column. What formula could I use so that the B column would look ...
0
votes
0answers
16 views

Need some help inserting break to prevent “Exceeded maximum execution time” Google Sheets script

I'm using a Google Sheet to populate drop downs in a Google Form. There's not a lot of info to be transferred as such, but it's repeated 76 times... I'll paint the picture first, so you have an idea ...
0
votes
0answers
7 views

Youtube won't let me move info-cards to their positions

I just uploaded a video and now I want to make the link to another video pop up in the moment I say "The video is in the info box", so I went to the card-editor. Youtube says I can move the cards to ...
0
votes
1answer
14 views

Is there a way to use unaltered Street View images from Google Maps in a travel blog that runs AdSense ads?

I use my own photos in my blog most of the time. Now and then, though, I feel I need to provide my readers with a reference point. Ideally, this is how I would do this: I'd take a snapshot of a ...
0
votes
0answers
15 views

Google calendar receive email invitation to your own event

I've been asked to write an application and one of the features is to allow users to add events to their Google calendar. They (calendar owner) have also asked to be able to get an email invitation to ...
0
votes
1answer
44 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?
0
votes
1answer
16 views

Google Sheets Formula - Trying to Sum, based on multiple cell criteria

I am looking for help with Google Sheets formula. The formula I need is - If A:A=LG and F:F=Indexed then sum the total of P:P for all of those instances. If A:A=PG and F:F=Indexed then sum the ...
0
votes
0answers
13 views

How can I populate and submit a Google form using info from Google Sheets?

I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
0
votes
1answer
9 views

Persistent notification in Google Hangouts Chat app on iPhone

The Google chat app has an extra persistent notification - all messages and room are "read" - It is always 1 more than Hangouts. - It does not go away with reinstalls - It does not display in web ...
-1
votes
0answers
18 views

abnormal access to administration Google site

I am the admin of website I sent an information email to 200 people containing a link to the website I manage. I realized that a person had access to the administration pages by a simple click on the ...
0
votes
1answer
25 views

Randomly assigning gmail label to every incoming email

I manage a team that has a shared gmail inbox, is there any build-in way to randomly label every incoming email to "distribute" the emails among the team members? To be more specific, what I want to ...
0
votes
0answers
7 views

Can you lock formatting rules? [duplicate]

I have set up a sheet as a rota. It uses a few conditional formatting rules to highlight things that might need attention, like if a cell is empty and if a date is within the next 2 weeks. However as ...
1
vote
1answer
20 views

How to see all custom formatting rules in a sheet, not just those applying to current selected cells?

As far as I can tell, in Google Sheets you only see a list of formatting rules applying to your current selection. Is there a way to see a list of all rules that exist in a sheet? When people copy-...
0
votes
0answers
13 views

Adding a tag to forwarded mails

Is there a way to add a tag, to certein massages, which are forwarded from one gmail account to another without using new filters and labels on the account which is the receipent of the forwarded mail?...
0
votes
1answer
16 views

Is accessing multiple Google Sheets Files(not multiple google sheets within the same Google Sheet File) in one script possible?

I was wondering if I can copy a certain range of cells in Google Sheet File A and paste it to another Google Sheet File B. More specifically, I'm referring not to sheets in the same Google Sheet(eg: ...
0
votes
0answers
6 views

How to fix wordpress website?

I have allitle question that my wordpress website when use the wifi it is work but when use internet from phone it show 404 error, if you met this experience please help?
0
votes
0answers
10 views

How to get in contact with Instagram

This is a follow up to my original question at : Instagram Sign Up Errors Leading to Wrongful Account Violation Notice It's been several days now and I still can't log into my account. When I enter ...
1
vote
1answer
25 views

How do I create a pie chart in google sheets without a category or two from my data?

I have a list of data, showing 4 items. Cats, dogs, giraffes, eggplant. I want to create a pie chart in google sheets that shows the pie with just cats, dogs, and giraffes. I don't want to show the ...
-1
votes
0answers
2 views

Finding Movies Efficiently? [closed]

I have a list of movie titles. Is there a website that would consider my list and tell me each film's availability and price (if applicable) on various streaming services (e.g. HBO GO, Netflix, Hulu, ...

15 30 50 per page