All Questions

0
votes
0answers
2 views

Prevent Gmail right-click from opening a New Message panel

If an email message contains an email address in the body, Gmail automatically converts it into a mailto: link, which is helpful. And many times each day I've enjoyed being able to right-click a ...
0
votes
0answers
7 views

Google Sheets | How to return what is missing in a 2 column list giving 2 comparison criterias?

Sample data: A B C D E F 1 name handed in students assignments name missing 2 a 1 a 1 b 2 3 b 1 b 2 ...
1
vote
1answer
10 views

Nested IF with FIND

I have a list of transactions in column A that I want to categorize. I want to search A1 for, say, "Shoprite" and if found return "Groceries", otherwise search for "Shell" and return "Gas", otherwise ...
-3
votes
0answers
6 views

BMW 2012 X5 problem

Is there a reputable dealer in the Orlando area who can work on BMW X5's who can repair an issue with the fuel tank and replace the head cover?
0
votes
0answers
4 views

Copy template to a new sheet referencing a cell number that is to increase incrementally

I have a template sheet that I would like to be able be able to copy with a unique name. Needing a single function to execute these steps: The document containing TEMPLATE is opened Button is ...
0
votes
0answers
6 views

Fractional formatting and math

Looked over the possibilities for help and coming up empty. I have written a spreadsheet which does some routine calcs for me. The problem comes in the formatting of certain cells. What I have: A ...
0
votes
1answer
20 views

How to correctly show contact names in Gmail

Most of my contacts are businesses, I was able to find the field "Archive as" in my Google Contacts which helped in organizing them. However when entering a contact in Gmail, it still shows the ...
-1
votes
0answers
8 views

How do I locked my Facebook profile!

Now a days I found in Facebook account if someone is not my friend, it's showing "THIS PROFILE IS LOCKED". I want to do same with my Facebook account. How shall I do that!! I mean the process. I saw ...
0
votes
0answers
6 views

Why is my Google Optimize reporting not matching Google Analytics?

Reporting of click events on images in Google Optimize isn't matching Google Analytics. Has my a/b testing experiment been configured correctly? I've created an Optimize experiment where I've ...
0
votes
1answer
8 views

How accurate is GitHub traffic analytics?

It seems to me that GitHub analytics is not very accurate. I have some repositories with 1-3 visits in 14 days, and one that gets 5-20 visitors a day. Even for repositories that get little to no ...
0
votes
2answers
18 views

How to get price of specific cryptocurrencies at specific times?

I have an assortment of cryptocurrency transactions over time. Various currency pairs at various prices. I need to figure out what the price of those currencies was, in Bitcoin, at the time that I ...
0
votes
0answers
7 views

How to Design a web application to dynamically update table from a file [on hold]

I would like to develop a web page that will have a table dynamically updated from different files on different server. So in order to maintain environment details we need a web page with different ...
0
votes
1answer
13 views

How to return all values (horizontal array) in B that has the same key stored in A?

Sample Sheet 1: A B 1 a x 2 a y 3 a z 4 b i 5 b h 6 b w Formula result, in Sheet 2, I am looking for: A B C D 1 a x y z 2 b i h w
0
votes
1answer
12 views

Google Docs copy paste formatting / indent question

So say I am taking a YouTube transcript, and copying the whole thing, and then pasting it into a document. The way the transcript is set up with YouTube it's layered like every 5 seconds so its lines ...
0
votes
1answer
25 views

Getting data from another Google sheet that isn't in the same order

I have a very basic knowledge of deeper functions of Google sheets and solving this has been a little bit of pain in the butt so far. I have a spreadsheet A column A contains ID column I that has ...
0
votes
0answers
8 views

Any hackpad-like front ends to github?

At work, we routinely use hackpads with LaTeX mathematics like hackmd.io for documents, but they should ultimately all land on github, so it'd be easier if they started there. Is there any similar ...
0
votes
1answer
26 views

Custom button or bookmarklet to toggle Conversation View On/Off

I'm trying to write a script that will add a button (or even use a bookmarklet) to toggle Conversation View on and off. This works, some of the time, to do the toggling: window.location.href = "...
0
votes
0answers
31 views

How can I even unsubscribe from a very annoying website? (pushnice.com)

I don't really hysterically even remember how I got to subscribe from this very annoying website. If I search for the website's name, an error will appear and the website will not be shown, so I ...
0
votes
1answer
28 views

Protect spreadsheet against duplicate data and sheet addition/deletion

There are some people that love to troll and spam my Google spreadsheet with useless info. Google Sheet lacks granular permission restriction. I need to prevent duplicate data from being submitted. I ...
0
votes
2answers
13 views

How to apply conditional formatting only if cell has X value? [google sheet]

I have a sheet with statistical data to which I had applied color scale conditional formatting. Some rows I set to have green for highest and red for lowest number in row and other rows the other way ...
0
votes
0answers
13 views

Creating something similar to deseat.me? [on hold]

So I stumbled upon this site Deseat.me and I'm pretty intrigued by its purpose. I've been trying to identify all the random unused accounts of mine I've made within the last 8 years but it's very ...
1
vote
1answer
19 views

Why is the total number of comments is larger than the counted number in Reddit?

I have seen this several times, for example, this post. At the moment of asking this there are only 6 visible comments, but the total number says it's 7. Why is that?
-1
votes
0answers
8 views

Why can't I visit a TLD? [on hold]

I see there is a large list of TLDs. Some of these are: BESTBUY BANANAREPUBLIC . . . etc. Does this mean we will be able to visit the TLD from a browser directly? Eg https://bestbuy.com would simply ...
1
vote
1answer
61 views

Is it possible to see all Gmail accounts by phone number?

I've created quite a few Gmail accounts for different projects, all verified with my cell phone number. Is it possible to see all the Gmail accounts connected with a specific cell phone number?
0
votes
0answers
6 views

Emails going into Updates folder

This is happening even though Primary is selected in Settings! I've tried to select Primary again and save.
0
votes
0answers
11 views

When starting a YouTube channel, is it best to register it? [on hold]

As in registering a company (Sole Proprietorship)? I am wondering if I should also get a WWW domain name? Or is it better to wait until I’m bigger and decide then? Thanks in advance guys/gals DPC
2
votes
2answers
36 views

Query returning #VALUE error when the column has no values

The below query returns #VALUE error when the column H is completely empty: =QUERY('Input Longo'!A8:S;"SELECT '000', A, B, C, D, E, ' ', F, ' ', ' ', ' ', G, ' ', ' ', ' ', '"&...
0
votes
0answers
9 views

I can't locate my google photos - I know they are there

I know that my google photos are somewhere in my google account. But for some reason, clicking on the google app icon only invites me to set up a new photos app. Yesterday,I found the photos ...
1
vote
1answer
17 views

Google Drive percentage goes back too 0% after being paused [on hold]

Today I decided to use Google Drive application on Windows to sync some files with my Google account. A few hours after the start of synchronization (33%), I decided to pause it and when I started it ...
2
votes
1answer
13 views

Return first vertical value that matches given criterion

On Google Sheets, I would like to figure out a way to have a cell return the first value in column C where the same row in column D matches the criterion ("Blue" for example, as opposed to "Red"). I ...
1
vote
1answer
21 views

Creating running total chart

I want to create a chart in Google Sheets with cumulative Profit (H) column but without creating the second column (I). Are there any solutions?
0
votes
0answers
16 views

Is it mandatory to have index.html file in repository to publish on GitHub Pages?

I tried to publish a site on GitHub using GitHub Pages, but it's showing only the repository name, nothing else. Do I have to put an index.html file?
0
votes
0answers
9 views

Excel script email [on hold]

I have been searching and searching and I can't get it working.  I am using google forms and I would like to receive by email the answers as data.    I.E. Column A will be Name, column B, age and ...
0
votes
0answers
18 views

Gmail: changing the Speaking language in emails

Sometimes I like the emails to be read for me by Chrome. When I highlight a text, there left mouse click option "Speaking". How do I change the language in this option. Thank you
0
votes
0answers
7 views

Hot to switch master data in google sheet

I have a spreadsheet with an overview of calculating some income based taxes now all tax percentages are fixed and for a specific year I want to move to have a list of master data: the percentages per ...
0
votes
1answer
16 views

How can I check my storage on my OneDrive for business account?

How can I check my storage on my OneDrive for a business account? https://faq.oit.gatech.edu/content/how-do-i-check-my-storage-usage-onedrive-business says: but I don't have the "site settings" ...
0
votes
0answers
15 views

Is there a way to allow markdown style code snippets in google docs?

I have seen a couple of methods of formatting code in google docs (e.g. here and here), and they both involve addons which then require you to go through menus (GUIs). Is there a way of changing ...
-1
votes
0answers
11 views

How to prevent YouTube from deleting my likes? [on hold]

I have realized that YouTube selectively deletes likes from some videos that I am sure that I have watched and liked before. This happens only on some videos. How can I prevent this from happening?
0
votes
0answers
7 views

Where can I see the message I sent to someone whom I asked to sign a document as a replacement signer in Adobe Sign?

I replaced a signer in a Adobe Sign form: By doing so, I had to write a message for them: Where can I see the message I sent to someone whom I asked to sign a document as a replacement signer in ...
2
votes
1answer
22 views

Enable grouping and ungrouping of rows in a locked worksheet (Google Sheets)

I need to share a spreadsheet with some locked cells, but it is necessary that the user can use the grouping and ungrouping functions of rows. Within the pooled range there are locked and unlocked ...
0
votes
0answers
11 views

Need help with a Python coding problem: [on hold]

Write a function, named Q4, that takes a strictly positive int input, N, and return a tuple, (p,q), such that N = pq with p,q > 1, If no such (p,q) exist then return the keyword None.
0
votes
1answer
3 views

Show insignificant zero

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
-1
votes
0answers
87 views

I'm having trouble logging into an old gmail account it is saying that they cannot verify the account belongs to me [duplicate]

Have old account need help getting into it password has been changed I've tried old password I have old phone number that is saying account can't be confirmed at this time when I go through all the ...
0
votes
1answer
16 views

Is there a way to add a “Copy to clipboard” button in a google doc?

I have a Google doc that has a bunch of templates that I need to copy and then paste somewhere else. I'm wondering if Google Docs has a function that lets me highlight a paragraph then add a "Copy to ...
-1
votes
0answers
6 views

How can i integrate my system with draw.io?

i want to know how can i integrate my system with draw.io. Have one api for this or a have to redirec to user to the page of draw.io?
0
votes
0answers
9 views

How can use private url in draw.io?

I'm making a system that integrates with the draw.io, and I need to export the url generated to my system, but when I do this, anyone who has access to this url can do edits in my diagram. my question ...
0
votes
0answers
15 views

Better UI for viewing Google Drive contents [on hold]

Does anyone know of an example of a custom Google Drive viewer similar to Awesome-Table? I like their Awesome-Table's widget-based search UI, but setting the attributes (for each file) is a ...
1
vote
2answers
26 views

Reset Google Search layout

I'm using Chrome on a Mac and all of a sudden my Google search layout switched back to its old interface with a black bar on top. I've tried logging out and logging in my account, cleared all ...
1
vote
2answers
18 views

YouTube - 4k 60fps - Dropping frames (Stutter/Lag/Freezes)

I'm trying to watch 2160p (4k 60fps) content on YouTube, however, I experience large amounts of dropped frames... i.e. the video freezes/stutters completely (the sound is fine). The YouTube example I ...
-2
votes
0answers
13 views

How to improve following code ,it shows error “TypeError: Cannot read property ”parameter“ from undefined. (line 8, file ”Code“)” [on hold]

function doGet(e){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1E8GVtQK5p8Nv6SwtUIE--P92pMYYXlNI3U7EXlzH_gk/edit#gid=0"); var sheet = ss.getSheetByName("...

15 30 50 per page