All Questions

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

Can I delete entries that don't appear in multiple sheets? [on hold]

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
13 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
14 views

Are Boolean expressions short-circuit 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
11 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 ...
0
votes
2answers
35 views

A formula to get total number of cells in an open-ended range

I need a formula to calculate the total number of cells in the range, including empty and not empty cells (i.e. the "size" of the range). It is more useful for open-ended ranges, like A:A, $3:$3, or ...
0
votes
0answers
48 views

How to remotely sign out from Backup and Sync? [migrated]

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
14 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
12 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
11 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
1answer
15 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
19 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?
4
votes
4answers
46 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
37 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
14 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
25 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
16 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
35 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
15 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
29 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
18 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
21 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
22 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
18 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
20 views

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

Can I make them always show the numbers?
-3
votes
0answers
7 views

Styleguide Generator for Mobile+Desktop [on hold]

I'm looking for a styleguide generator similar to Astrum which is essentially an easy angular app to generate a styleguide out of markdown - together with code preview. I need a parallel view for ...
0
votes
0answers
14 views

Google Docs thinks that I am using an Apple keyboard even though I'm not (non-Chrome browser)

I'm using the Gnome Web browser on Linux which happens to be my favorite browser. I'm having an issue with all Google Docs applications where it assumes I'm using an Apple keyboard when I'm not. This ...
0
votes
2answers
17 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
0
votes
0answers
37 views

How to append data to desired column in Google Sheets?

I have created Google sheet having two columns A & B. I want to enter "In time" in column A and its corresponding Out time in column B. I have created two python scripts which append data to the ...
0
votes
1answer
13 views

Google form anonymity in organization

I have a Google account that's part of an organisation. There's this form that only people in the same organisation can respond to. Is there a way for the owner of the organisation to find out that it ...
0
votes
1answer
17 views

How to add an entire forum to the Wayback Machine Internet Archive?

There's a forum that I like to read because it has a lot of useful technical information on it. But the site is owned by one person and I'm worried he might retire. I checked archive.org and it ...
0
votes
1answer
11 views

Average value using different sheets on Google Sheets

I have a data set that's separated by year (so, the first year is Sheet1, the second year is Sheet2, and so on. There are 18 years in total). I want to average the data from different years. At first, ...
0
votes
0answers
29 views

Gmail doesn't let application connect through IMAP

There is an EXE which runs on other people's computers and manages itself by using gmail. Since different PCs have different IPs, we need google to let all IPs to access mail through IMAP. I have ...
1
vote
1answer
21 views

How can I list rows meeting a criteria and limit the amount of rows by a sum of the list?

I am trying to create a scheduling assistant within Google Sheets. I need to list out tasks currently scheduled for a specific date but there is a volume cut off that needs to happen. Client ...
0
votes
0answers
30 views

URL code for Google Form section

I have Google form with 10 section(lets call it page), and I use app inventor to create the mobile interface. The problem is when I get the pre-fill link with a link to be execute: https://docs....
1
vote
1answer
20 views

Is it Blogger or LibreOffice who is adding so many useless SPAN tags into my text, and why?

I write in LibreOffice Writer, then I copy and paste into Blogger text editor (Compose button). Why in the world a simple and unformatted text such as Helmut Sick (Tukani: entre os animais e os ...
1
vote
1answer
8 views

Google Sheets Circular Dropdown Dependency

Suppose we have 2 columns Id & Name which contained in sheet1. Now in sheet2 have dropdown for Id & Name which user can select and it Lookup value for each other (select Id from dropdown, Name ...
0
votes
2answers
16 views

How to work over rows from all other sheets in Google Sheets?

I have a 'summary' sheet and 12 other sheets named 'Jan20', 'Feb20', etc. In the summary sheet I have this formula (to calculate Uber costs): =FILTER('Jan20'!F2:F, REGEXMATCH('Jan20'!D2:D, "UBER")) ...
1
vote
1answer
31 views

How do I to access a deceased family member's Hotmail or Outlook.com account?

I can not access my deceased wife's Hotmail account. I do not know password or have access to the phone number to get the pass code. The phone number that was used when account was sent up says the ...
0
votes
1answer
15 views

How do I find the Twitch channels I'm an editor of?

There used to be a way to list all the dashboards that you have access to (your own, plus any you are an editor of). Can't find it now, and am wondering where to go looking. You automatically have ...

15 30 50 per page