0
votes
0answers
7 views

Change color of query-filled cell via script based on cell content

I used the following script proposed in a different question (How can I change the background color of a cell based on the cell contents using a color lookup sheet?) to change the background and font ...
0
votes
1answer
8 views

Use text and images in a google sheets header / footer

In google docs i can apply a header and footer which can contain custom text or images to a doc. In google sheets I can see how to apply a footer but it seems to only allow me to use standard data ...
3
votes
1answer
17 views

Google Forms: Number Ranges Appear as Dates

I have a Google form intended to be filled out by teachers. One of the questions is about student ages. The choices are checkboxes with age ranges, so [ ] 0 - 5, [ ] 6 - 11 and so on. The two ...
0
votes
1answer
8 views

Google Drive API - Search for documents shared externally

I am a GSuite admin and would like to find a way to use the Google Drive API to find documents that have been shared with users outside of our domain. I have been using the service.files().list() ...
0
votes
0answers
10 views

How do I shift all of my words, so they align only in the left column?

How do I shift all of my words into the left side of the column without just repeatedly using enter? I'm trying to do some qualitative coding, so all of my interview transcripts need to go on the ...
1
vote
0answers
6 views

How to create a google sign-up sheet

Is it possible to create a Google sign-up form accessible via iPhones etc. without the need for a Google account? We find we can open from a computer but not a phone if you don't have an account.
0
votes
1answer
24 views

How can I find my Google Account name?

I can't remember the name of one of my Google accounts (account a), but it was signed in on a computer that was signed in to a different account (account b). is there a way to find account a in the ...
-1
votes
0answers
6 views

Managing/moving calendar event invitations to separate calendars?

I think this is a basic enough problem that I would assume a good solution/workaround already exists, but I'm having difficulty finding it. To give a specific example, I'll be discussing Google ...
0
votes
0answers
14 views

Creating a Dashboard in Google Sheets which multiple people use issue with multiple users

this may be open-ended but let me put this forward. I have a very complex dashboard which works out staff hours across the country. In this dashboard our team members have a drop down to choose their ...
0
votes
1answer
13 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
0answers
6 views

Move large folder from personal Google Drive to a Team Drive

My place of work uses G Suite apps. For the past five years I have shared with my team a Google Drive folder, which we have maintained as if belonging to the team. I'd like to migrate the contents ...
-1
votes
0answers
8 views

Why does uploading affect my download speed?

I've been uploading several videos lately, and I've noticed that when I do my download speed is reduced to an absolute crawl - even though I do not see how one should impact the other. Is this a known ...
1
vote
0answers
12 views

Adding multiple RSS feed loop “chunks” in single email send (instead of single aggregation) [on hold]

I have looked at dozens of marketing/email platforms, aggregation tools, and open-source resources, but cannot for the life of me find a viable solution to this: Premise: I have a client that wants ...
-1
votes
0answers
10 views

Gmail Get Hacked [duplicate]

I have change my password and do whatever to get my gmail back but when I try to log in it say google can't verify this account belong to me. Please help me.
2
votes
1answer
18 views

How do I find the Nth match in Google Spreadsheet?

On MS XLS I can do some aggregate or leech off a structured reference, but I really don't know how to find the an Nth result based on word match on Google Sheets. I have huge columns - name, role. I ...
0
votes
1answer
20 views

Where can I change the URL for a Google+ business page?

Where can I change the URL for a Google+ business page? I've tried looking in the Google+ dashboard, but couldn't find anywhere to do it.
0
votes
0answers
10 views

Password on the folder for public use

I want to put the dataset in the Dropbox folder wants to share that folder to public. Within that main folder there is one more folder and I want to put password on that. So if anyone want to access ...
0
votes
0answers
7 views

Checking the integrity of files (corrupted or not) on Google Drive

I've been using Google Drive to backup my files (a lot of big files). My question, is there any way to check whether or not the files on Google Drive are really the same as my local files? That means ...
0
votes
2answers
38 views

updating a cell with fixed format without using code, formulas only

i have cell A1 = 1,0,0,1 cell B1=,1,,-1 I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there ...
0
votes
0answers
10 views

I can't send to pasted or linked to emails.

This is a weird one. I can send to all address just fine if I find the address in the directory or type it in, but for addresses I copy and paste from a website or that I try to send after clicking a ...
0
votes
1answer
13 views

Is it possible to change Microsoft Outlook web interface's settings so that opened emails from the unread email list are marked as read?

When I list unread emails in Microsoft Outlook web interface: then open one of the unread emails, the email is still marked as unread. Is it possible to change Microsoft Outlook web interface's ...
0
votes
0answers
11 views

“Imported content is empty” error when using IMPORTXML for loading an auto-refresh list to Google Sheets

I'm trying to import data from a table that shows the most recent active calls made to the Orange County Sheriff's Office. The table refreshes every 60 seconds. The table: https://www.ocso.com/calls-...
1
vote
1answer
15 views

Color all cells in Google Sheets that contain data present in a set

I have a Google Spreadsheet having possibly thousands of IP addresses extending from column A1 to column CS2990 And I have a list of about 100 IP addresses I need to color all the cells in Green ...
-1
votes
0answers
6 views

Is there a way to know the number of followers of a twitter user on a certain past date?

Is there a way to know the number of followers of a twitter user on a certain past date? For example: How many followers did @StackOverflow have on 01/01/2016?
0
votes
0answers
8 views

Installed Evernote not syncing web version notes

For some reason, I can't get to my notebooks I made on Evernote Web from the desktop client. I found someone facing the same issue: https://discussion.evernote.com/topic/100780-evernote-on-computer-...
0
votes
1answer
23 views

How do I get GMail to wrap my paragraph text in the default html mode?

I've been noticing of late that when I write paragraphs that end up needing word-wrapping as GMail will make these lines extremely long and cause horizontal scroll bars and hence make having to read ...
0
votes
0answers
21 views

Is there a way to download new gmail attachments to desktop and rename it based on a Google Sheets cell in a spreadsheet?

Is there a way to download new gmail attachments to desktop and rename it based on a Google Sheets cell in a spreadsheet? Quite basically I am looking for a way to download or change a filename thats ...
0
votes
0answers
8 views

What Does Google Alerts “only the best results” versus “all results” mean?

What Does Google Alerts "only the best results" versus "all results" mean? Does it filter out obvious spam, or does it hide lower quality results (that could be the needle in the haystack)? Or does it ...
0
votes
0answers
11 views

Why does “Auto Add to playlist” not work in Youtube?

I record screen capture videos of various things I do, and want to be able to upload them automatically to a playlist to share them with some associates. Youtube has a feature for this called "Auto ...
-1
votes
0answers
9 views

Fetch All Suggested Friends from People You May Know

Without having to write any webscraping code, is there any way I could get a list possibly in excel sheet format of all the people that facebook is going to recommend to me as friends. This would ...
-1
votes
0answers
6 views

Can I search for a specific word, while only showing my followers tweets on tweetdeck?

I was wondering if I could catch sub-tweets but since my twitter name is cozy there are loads of other users who use this word in their tweets which don't really interest me, and I couldn't find an ...
0
votes
1answer
15 views
+50

The total number of items in my “Inbox by Gmail” inbox

I need to know the total number of items (emails + reminders) in my "Inbox by Gmail" inbox. Is there a way?
1
vote
1answer
23 views

Split columns in to rows in google spread sheets [duplicate]

I have following table: ID Event Event2 Event3 102 181 182 184 103 5 7 8 I want to convert in into: ID Event 102 181 102 182 102 184 103 5 ...
-1
votes
0answers
42 views

Forgot Gmail username [duplicate]

I forgot my Gmail Username. I remember the phone number and the backup email that was provided while creating the account. Recovery asks me to enter my first and last name, which I don't remember as ...
0
votes
0answers
25 views

Google Photos vs Google Drive: How do I find out which copy of my photos in my Google Account is the original?

I have used Drive for years, and had all my documents including photos backed up there. Then at some point later, Google Photos became a thing, and Google began nudging me towards using that instead ...
-1
votes
1answer
25 views

Instagram confirmed account but can't get the security code

What do I do? I don't have access to the number it's sending the security code.
0
votes
0answers
38 views

Gmail want my phone# [duplicate]

I start using VPN, so the IP address change from time to time. Then Gmail doesn't recognize it is me and wants to have my phone# for verification, but I don't want to give my phone# out to Gmail. This ...
2
votes
1answer
22 views

AVERAGEIFS ERROR “Divide by Zero”

I'm trying to calculate an average # days an account has been open if all 3 specific conditions are met. Average range: R6:R102 Conditions: A6:A102 = "x" S6:S102 = "* EWS *" (contain part of EWS) ...
0
votes
1answer
8 views

How long does amazon promotional credit last?

I just got a £5 promotional credit from amazon but don't know how long will it last. Any idea?
1
vote
0answers
19 views

Google Apps Script - how to hide run message

I have a question about running apps script on a Google Sheet. I have a few scripts written that can apply a filter and remove a filter. When I run the script from the button on the spreadsheet the ...
2
votes
1answer
66 views

Why does Gmail force a dot in my email address?

Google insists that dots don't matter in an email address. However: If I attempt to log in with firstnamelastname@gmail.com then it tells me I'm logged in as firstname.lastname@gmail.com. I am ...
0
votes
0answers
10 views

Send email automatically based on consecutive cell values

I am working with an attendance spreadsheet and trying to find a way to trigger the automagical sending of an email when certain conditions are met. If a student is AE or AU 5 days in a row (see ...
0
votes
2answers
30 views

What exactly do Gmail's “Yes, that would be fine” answer buttons under a mail message containing a question do?

After I switched to the new Gmail web interface I've received a mail message of the form Would it be acceptable to you if <...> To my surprise I found three buttons under the message below the ...
-1
votes
0answers
26 views

Password Forgotten For Recovery and main account [duplicate]

Both Recovery And main Gmail Passwords have been Forgotten. I Only Remember my Main gmail Name But Not my Recovery Gmail name Please help. Also i Have No Phone Links.
-1
votes
0answers
17 views

After upgrading to the latest Chrome from 68.0.3440.* to 68.0.3440.106, all the saved passwords are gone, what now? [migrated]

Chrome used to remember all my passwords. Which is a very important feature because I have more than 2 laptops. However, after upgrading to the latest version (as for now it's 68.0.3440.106), all the ...
0
votes
0answers
9 views

Draw.io Scaling a background plan to calculate area

I'd like to use the attached floorplan in Draw.io. If I trace over the drawing I will get a workable and editable version of the plan. Does anyone know how to set a scale on Draw.io that can the ...
0
votes
1answer
16 views

How to not count cell if cell contains sub-string

I have the following formula to count cells within a range B10:B1095 which do not contain certain strings =COUNTIFS( B10:B1095, "<>", B10:B1095, "<>Manual", B10:B1095, "<>TODO"...
0
votes
0answers
7 views

How can I find and replace text on Google Form [on hold]

How can I find and replace text on Google Form using JS on Script Editor?
0
votes
0answers
7 views

Update Cell If another cell is not empty - Google Script

There are two columns N and O. When any cell in column N is filled the adjoining cell in column O needs to filled with "Yes" if not it stays empty. This is the script I'm using. var s = ...
0
votes
0answers
5 views

In Google Drawings, how to I “snap to guides” based on a specific object?

I really like the "snaps to guides" feature in Google Drawings, but sometimes it can't find the guides for the reference object I'm interested in. This happens when I have a lot of objects, and the ...

15 30 50 per page