All Questions

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 ...
1
vote
1answer
22 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
17 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
32 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
1answer
5 views

Azure DevOps Organization Setting

There are multiple organizations listed when I go to our Azure DevOps. I own one of the orgs and manage all projects for the company there. I would like to move my Organization to the top of my orgs ...
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
29 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
1answer
48 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
29 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
14 views

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

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
14 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
20 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
84 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
7 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
13 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
38 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
10 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
22 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
10 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
22 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
20 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
17 views

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

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

Need help with a Python coding problem: [closed]

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
9 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
17 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
17 views

Better UI for viewing Google Drive contents [closed]

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
32 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
21 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“)” [closed]

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

How do I bulk download all images of a digitized manuscript?

There is a book I would like to save as a pdf, from the Digital Bodleian website. However, I cannot see a way to quickly grab all 400 .jpeg images for further processing. The software seems to require ...
-2
votes
0answers
9 views

Download google Drive File in Java [closed]

I wont to download uploade document of google drive Using Java. I also completed upload process using java but i have no idea about download.
0
votes
0answers
7 views

How can I link to a specific event in a public calendar so others can view without signing into Google?

I would like to share an event in a public Google Calendar. When I click the event, it pops up with the description, but doesn't change the URL to copy. If I click Options > Publish Event > Copy Link ...
2
votes
0answers
34 views

How to invite into secret Facebook group?

I run a secret Facebook group. When I need to add a new member, I paste an email address into the Invite Members box on the right panel: Sometimes it works as expected. However, 90% of the time I ...
0
votes
0answers
3 views

How to alphabetize all worksheets in a Google Sheets project

I am trying to alphabetize all worksheets within a Google Sheets project (there are around 150 worksheets in one project.) I have tried the following script, but it places the worksheets in random ...
2
votes
0answers
16 views

How to remove contact from Hangouts? [duplicate]

I can't find anywhere an action to this. I need to remove the name of a dead person in my Hangouts contacts. I can only seem to Block or Hide a name. Does anyone know how to remove the name ...
1
vote
1answer
14 views

Ban a specific user from commenting on Google Docs

I have a Google Docs document that I allow public comments on. Lately, one specific user has been repeatedly adding unhelpful comments and hiding (marking as resolved) all of everyone else's comments. ...
1
vote
2answers
21 views

Conditional formatting rule that compares against a range of values

I have a list of 2019 dates (col A) and holiday dates (col G). Wherever there's a date in col A that matches any date in the range G2:G20, I would like to highlight it in grey. See this sample ...
0
votes
2answers
20 views

How to scan rows for match with ArrayFormula?

Trying to search a row for a given value, but want to make an ARRAYFORMULA so that every time a new row is added the search will be performed on that row. Currently using =IF(COUNTIF($A2:$EI2,"="&...
1
vote
1answer
27 views

How to multiply a query column by a cell refference on Google Sheets?

Below is the query that I use, and it works: =QUERY(Input!A2:I33; "SELECT '000', A, B, C, D, E, ' ', F, ' ', ' ', ' ', G, ' ', ' ', ' ', '"&TEXT(Input!L8;"dd/mm/yyyy")&"'...

15 30 50 per page