All Questions

0
votes
1answer
8 views

How can I transfer the contents of hundreds of emails to a single Google Docs/text editor document?

A friend and I write together, via email, back and forth a little at a time. we have already once taken a few hundred thousand word story and painstakingly copied and pasted it into a Google document.
1
vote
0answers
5 views

Making a group email list for multiple org members to get emails from external sources?

In the past it was pretty straight forward to make a group with proper permissions without worry in Google Apps' Groups Admin function. I frequently used it to create a recipient group for services ...
0
votes
0answers
3 views

create a google classroom assignment in which students cannot attach files

How can I create an assignment that only allows students to submit their answers via an attached form? I tend to assign questions to be answered via forms, but sometimes students answer by attaching ...
0
votes
0answers
4 views

Google Slides with data from Google Sheets

Is there a way to insert Google Sheets data into Google Slides? I want to print certificates using Google Slides (certificate template) and then grab data from Google Sheets, like a mail merge. Is ...
1
vote
1answer
8 views

Change e-mail used to send Google Calendar invites

I have two emails a@gmail.com and b@work.com linked to Gmail from which I can send emails. Now in Google calendar I can send calendar invites to emails, which are sent by a@gmail.com (It says a@gmail....
0
votes
1answer
6 views

MATCH a cell value, then return the value of the cell next to it

Is there a way to use a MATCH formula to look up where one value appears and then use that returned index as the point to reference to find another value? Right now I have a spreadsheet set up where ...
0
votes
1answer
6 views

Gmail Forward email to group, with recipients replying to specific person

I forward a LOT of emails every day. Most of the time, people reply to who they need to. Example. "Do you need money?" Email. Forward to people who need money. But I don't need them to reply to me, I ...
0
votes
1answer
8 views

How to use complex filtering queries in Gmail?

I am playing with different/complex filtering queries/string in Gmail. I found this answer (to my own question): after:1552896000 before:1552924800 And I was able to use it without any problems, i....
-1
votes
0answers
5 views

does the callback will be invoked again after parent function complete while callback invoked once intentionally in parent function

use this code as a demo: const timeFuncRuntime = funcParameter => { let t1 = Date.now(); funcParameter(); let t2 = Date.now(); return t2 - t1; } const remind = () => console.log(...
-1
votes
1answer
6 views

We are working on it and we'll get it fixed as soon as we can. « Back to Home

What is We are working on it and we'll get it fixed as soon as we can. « Back to Home In facebook how to get it fixed
0
votes
0answers
13 views

How does Ranker.com detects fake votes without login?

I checked the Ranker.com website and their voting system cannot be fooled through basic changes in our public info. This is what I did to check how their voting system records votes without the user ...
0
votes
2answers
14 views

Function to search columns and tally data

I am wondering if I can write a function to search a column in my spreadsheet for a specific name, then return x number of values within the row(s) that contain the name. For example... M4 holds the ...
1
vote
1answer
11 views

How to arc line over swim lane?

Does anyone know how to set Draw.io to support line jump arcs over swim lane borders? As per the attached screenshot, the jumps work fine elsewhere. I also tried sending the swim lane thing to the ...
-1
votes
0answers
10 views

INSTAGRAM LOG IN HELP

Help! I dropped my phone in a watery grave a week ago, got a new phone and am only able to log into my business instagram! I have tried to reset the password for my personal one, and it keeps sending ...
0
votes
1answer
13 views

Undo Send - works on some computers but not others. Is Chrome required?

Does it only work with Chrome? Not FireFox!? Undo Send - works on some computers but not others. Is Chrome required?
0
votes
0answers
13 views

How does Google Mail exact match search work with special characters?

If I search in Google Mail for "a-b-c", it returns "a-b-c" but also "a b c". Similarly, if I search for "a b c", it returns "a b c" but also "a-b-c". In fact, "a b c" returns "a b c", "a-b-c", and "...
-1
votes
0answers
24 views

Can I please keep the things I liked about Inbox?

I'm incredibly bummed that Inbox is going away because it made Gmail tolerable for me and the things I'll miss aren't on any of their "how to keep the features you love" posts: The inbox bundled by ...
0
votes
0answers
8 views

Trying to find real website merchants that accept Apple Pay or Google Pay (W3C Pay) as payment methods [on hold]

I've been conducting technical research of the online payments sector, comparing many payment solutions. I've explored both the Apple Pay and Google Pay APIs and I see that they both support Web ...
0
votes
1answer
15 views

Can I delete entries that don't appear in multiple sheets?

I am using the college scorecard dataset, which separates different years into different sheets (so, data from 1996 would be in sheet1, data from 1997 would be in sheet2, and so on). Since colleges ...
0
votes
0answers
9 views

How can I prevent users from “resolving” comments in Google apps?

I would like to give users the chance to comment on a Google doc but not to resolve comments I or other editors made on it. But if I invite a user in "comment" mode it seems they can resolve comments ...
-1
votes
1answer
11 views

Are Boolean expressions fast evaluated in Google sheet formulas?

Suppose I have the following expression repeated in a long column: =IF(OR($U2=""; COUNT(aHugeRange)=0); ""; SUM(aHugeRange)) I would like to avoid performing COUNT() and SUM() as much as possible to ...
0
votes
0answers
8 views

Are Gmail Signatures Configured by Device?

We recently worked on updating some signatures for the organization I work for, and are noticing an interesting trend... users who log in on multiple places have to reconfigure their signature each ...
-1
votes
1answer
18 views

How to get size of a dynamic range or determine the current size of the sheet? [on hold]

I need to calculate the size of a dynamic range, like A:A, $3:$3, or A2:A. When I say the size of a range, I mean the total number of cells in the range, including both empty and not empty cells. ...
1
vote
1answer
21 views

How to remotely sign out from Backup and Sync?

Suppose I have a laptop with Google Chrome and Backup and Sync installed and my Google account logged in for both of these applications. Then, if my laptop gets stolen, I want to remotely sign out my ...
1
vote
2answers
13 views

How to combine a formula with text in one cell?

My spreadsheet contains data divided into weeks in a year and I would like to combine the following two pieces of information in one cell: =ISOWEEKNUM(TODAY()) Calendar week 'Calendar week' being ...
1
vote
1answer
10 views

vlookup sum to calculate total hours assigned next to dates

I'm attempting to calculate a total number of hours based on entering 2 different dates. Each day between the dates has assigned 'hours worked'. I'm trying to use Sumproduct or Arrayformula and Sumif,...
1
vote
1answer
10 views

Will YouTube continue to support Gameshow for live streaming?

A few days ago, I opened up Gameshow to start a live stream. Then I came across this message: For the next year we will be updating Gameshow when necessary, but after January 1, 2020, there will no ...
0
votes
0answers
10 views

How can I use GOOGLEFINANCE to return a share price in a certain currency?

I have shares in different currencies that I want to track in only a single currency. I currently have a cell that returns the currency and one that returns the price, I then multiply them. However, I'...
-2
votes
0answers
11 views

Splitting up Google Sheets vs. keeping everyone on one sheet [on hold]

I've got some Google Sheets with lots and lots of formulas and arrayformulas (especially vlookups), and they can get really slow. I've discovered that if I split them up into smaller sheets and do ...
0
votes
0answers
16 views

How to copy from a protected Google doc?

I just came upon a Google doc from a high school account that I no longer have access to. I want to copy paste my work, but the copy paste functionality is disabled. I know you could access developer ...
0
votes
0answers
8 views

Google Form File Upload - Change File Name to Match Form Value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
-2
votes
0answers
11 views

Someone else trying to lob in to my account [duplicate]

I keep getting a message every hour for the last 3 hours that the 'sign in to my account has failed'. I have not been trying to log in to my account so obviously someone else is. What can I do to ...
0
votes
1answer
10 views

How to access your email account from Microsoft Office 365

I have logged into the Microsoft Office home page and the screen looks like this: How to proceed to view new email coming to my university account?
3
votes
4answers
44 views

Joining two rows of data with alternating delimiters

I'm working with two rows of values that are related to each other and trying to build a formula that will compile the data into one cell, with syntax that uses two delimiters. If a cell in the ...
0
votes
0answers
7 views

Zapier Google Contacts Integration | Error Uploading Contact Image

I am testing a Zapier integration which takes contact information entered through a Google Form, stores contact in a Google Sheet and, via Zapier, upload the new contact to Google Contacts. The ...
0
votes
2answers
33 views

Search e-mail messages in given period of day or in given period of week

Is there any way in Gmail's filtering mechanism to find e-mail messages received or sent: in a given period of a day (each day -- only time component of date matters here), in a given period of week (...
-4
votes
0answers
13 views

How does (implementconsultinggroup.com) achieve such smooth transitions between subpages? [on hold]

website - try clicking the 'back' button and perhaps clicking one of the images afterwards. Observe the smooth transitions between the subpages of the website. How did they achieve that?
0
votes
1answer
23 views

When someone shares a Google doc or presentation with me, I no longer get an email notification. How can I fix this?

When a teacher or peer shares a google doc, presentation, or spreadsheet with me, it no longer appears in my Gmail. I have checked my spam, trash, and all my folders. It used to send a notification, ...
0
votes
1answer
8 views

Concatenate using an array formula to result in last name.firstname

We have a form that asks for the students first name and last name. I am trying to using concatenate and an array formula to display "Lastname.Firstname". I used: =ARRAYFORMULA(CONCATENATE($B$52:$B,...
0
votes
1answer
14 views

Using Google Script to place Duplicated Google Form Responses in one Column?

I have a Google Form, with multiple sections, and duplicated questions. Google Forms Automatically creates separate columns in the resulting Spreadsheet for each question, even if it is the exact same ...
0
votes
0answers
34 views

How can I make all sent emails appear in inbox (no solution 5+ yrs ago)

So, I'd like to have all my sent emails automatically show up in my Gmail inbox, without cc'ing myself, if possible - can this be done in a fairly simple way?
0
votes
0answers
13 views

Permanently block persistent/creepy “upload picture” panel in Gmail/Hangouts

Modern Gmail (this started in 2016-2017) has this extremely annoying nag where if you accidentally click your blank profile photo, it pops up a panel demanding you upload your photo that doesn't close....
-3
votes
1answer
28 views

Whatsapp sending from Chrome [on hold]

I'm developing an app to send messages in Whatsapp using JS. My app simply call the url below with the correct get parameters : https://web.whatsapp.com/send?phone=9999999999&text=Mytext It's ...
0
votes
1answer
21 views

Concatenating URL with a value to create link, but links only works partially

I have a column of cells in Google spreadsheet with values such as: b2397 b9504 b3333 b8655 bxxxx I would like to combine each value with a URL, for example: http://websitex.com?id= ...
-3
votes
0answers
10 views

Using Microsoft Word as editor in web application [on hold]

I need to edit texts in my web application and would like to use Miscrosoft Word as an editor. I saw in another system something like that where the user clicked a button and a new window was opened ...
-2
votes
0answers
16 views

What MediaWiki modules must be rewritten in order to use it as a software repository? [on hold]

The goal is not storing small independent code snippets, like various wikicode projects did. They are dead now. The goal is storing working software modules, by using a really dirty hack. One article ...
0
votes
1answer
19 views

With the destruction of Album Archives, where will all of the photos from a Hangouts be stored?

I have received many notifications from Google saying that Album Archives and Google+ are going away as no one is really using them. In this case, where will all of the new photos from Google Hangouts ...
0
votes
2answers
21 views

Row height would not auto-adjust to fit content anymore

I selected the whole sheet and re-sized the height of all rows at once to a certain height by clicking "Resize rows 1-1000" in the context menu. Then I entered some text in a cell and the text did ...
1
vote
1answer
17 views

Can you view your total upload hours on YouTube?

I was trying to see how many hours of content I had uploaded to YouTube (preferably without counting it all by hand). I was wondering if there was a way of viewing this. I looked through all the ...
1
vote
1answer
18 views

Why do some YouTube “Subscribe” buttons show numbers and some do not?

Can I make them always show the numbers?

15 30 50 per page