All Questions

2
votes
1answer
32 views

Recovery of Discarded Draft [on hold]

Suddenly in discarded, all of my Drafts... Is it possible to recover them somehow?
0
votes
0answers
13 views

Formatting script applicable to a range, not an entire sheet

I have the following script, which applies formatting in row 1 to an entire spreadsheet. How can I limit the formatting application to a range (ex. A7:AN135), so that the header rows are excluded from ...
-1
votes
0answers
14 views

How does an irc daemon like Charybdis work? [on hold]

I am pretty new to irc, and am poking around in it to try and understand it. I am running CentOS 7 on a VM, and have installed charybdis-4.1.1 and atheme-7.2.10-r2, using this marvellous guide. ...
0
votes
1answer
16 views

Google Spreadsheets timestamp

I'm trying to have a timestamp automatically appear in column L (12) in a Google Spreadsheet if a tick box is ticked on the same row (in column A). The app script code that I modified from this source ...
-1
votes
0answers
6 views

JItsi Meet install Issue [on hold]

This is the error I'm getting root@TwoWayCast:~# /usr/share/jitsi-meet/scripts/install-letsencrypt-cert.sh This script will: Need a working DNS record pointing to this machine(for domain ...
0
votes
0answers
5 views

Display name of sheet with highest value in cell

I have a sheet for each data set i have. I want to display in a cell the name of the sheet with the highest value in all the B2 cells.
0
votes
1answer
7 views

How do I insert different cell data from a table into a hyperlink?

I have a table of different cell data that I want to insert into different hyperlinks for each item: =HYPERLINK("https://www.otcmarkets.com/stock/CELL DATA TO BE INSERTED/security","SECURITY") Cell ...
-1
votes
0answers
23 views

Why does the search function on facebook not work properly?

When I scroll down on a page on facebook with a fair amount of posts, there seem to be a significant number of older posts simply missing. Even when you use the search bar they don't seem to come up. ...
0
votes
0answers
10 views

how can i find and append a cell with script editor in google sheets

I have a script that will find the value in a lookup from column b and column a what I am trying to do is find the row and append the data in column n of that row is there a way of doing this, the ...
0
votes
0answers
12 views

How do you make the graph relative in Google Spreadsheet?

I have a simple graph in Google Spreadsheet just showing weights from different dates. The problem I have is that the graph is starting from 0, giving it a lot of dead space. I want it to be relative ...
1
vote
1answer
10 views

Google sites: How to edit the title tag of a page

I created a site in the new Google site with just one page. I'd like to change the title tag so it s name is correctly displayed in search engines. The title of my page is "home" Is it possible?
0
votes
1answer
20 views

How to assign internal names (“programmatic”/cryptic and non-visible for the form participant) for each question in a google form

Is there any way to set question cryptic-name/variable in addition to the question visible to one answering the form. What I need is that when I export forms questions to google sheet I can ...
0
votes
1answer
10 views

Why my Google earth exported KMZ file is not a XML file but a binary one?

According to wikipedia, kmz is a: DescriptionKeyhole Markup Language is an XML notation for expressing geographic annotation and visualization within Internet-based, two-dimensional maps and three-...
0
votes
0answers
5 views

Is there a keyboard shortcut for “Accept Suggestion” in Google Docs?

I do a lot of reviewing suggestions in Google Docs and I have the cursor "within" suggested text and would like to accept/reject the suggestion with a keyboard shortcut. From what I can tell there ...
0
votes
1answer
7 views

How to ignore certain strings when creating unique list of words in Google Sheets?

In Google Sheets, I am using the formula to create a unique list of words: =unique(transpose(split(ArrayFormula(concatenate(B2:E"+")),"+"))) But I want to filter out certain strings. My unique list ...
0
votes
0answers
9 views

Working with several google calendars and display it to people

I'm using 2 google calendars - my personal calendar and my work calendar. I had many problems with coworkers meetings that scheduled for free time in my work calendar while I had other meetings in ...
1
vote
1answer
7 views

Automatic cell coloring via conditional formatting

I am working on a sheet for a game I play and having some trouble with cell coloring. I have one sheet, named "PlayerList" which maintains a list of player names, class and role. Players are ...
0
votes
2answers
7 views

How to create a unique list from a selected range of cells

I have a list in cells A1:A16 of foods and want to create a unique list with each item only appearing once in the list: Eggs Bacon Hashbrowns Baked Beans Avocado Coffee Bread Bread Sandwhich meet ...
0
votes
1answer
17 views

Method to preserve cell reference in a formula upon adding rows in reference sheet?

I have a Google Sheets with two(2) tabs. The first sheet is just a running tally of raw data and is updated with new rows at the top weekly. In tab 2 there is just a single query(arrayformula)... ...
0
votes
1answer
22 views

How can I see backups for corporate accounts in Google Drive?

I have a personal and a corporate Google account, the corporate being in the domain of my company. When I head to my personal account, I see a tab "backups" in the left side of the page as shown in ...
1
vote
0answers
241 views
+50

How to restore Gmail password if I still have an access to this account by redirection

I added another Gmail account to my primary Gmail account years ago through the Accounts and Imports option. I can get and send emails to/from this account, but I cannot log in into this account ...
1
vote
2answers
10 views

Get email notifications for pr's and issues on my github repo

How can I get email notifications when somebody opens an issue on a repository I own ? I have a small open source plugin I manage, and when a user reports an issue, or send a PR, it's important for ...
0
votes
1answer
12 views

Is it possible to have Twitter alert me when someone tweets?

I have twitter installed on my iPhone and wanted to know if it was possible to have my phone alert me when a particular user tweets?
-1
votes
0answers
18 views

problem with notifications on facebook

recently I tried to log in to my Facebook account from a different PC and realized that I have 23 notifications (attached picture) but when I logged in there was no notifications. do you know how I ...
1
vote
1answer
8 views

Google Sheets referencing a cell adjacent to a cell on another sheet

I've got a calendar in google sheets with each cell referencing a cell value pulled from weekly sheets. I'd like to be able to enter the cell reference for the first of the month, then have the rest ...
0
votes
0answers
9 views

What is the correct limit on PC “unanswered invitations” in EasyChair?

We would like to add more PC invitations in EasyChair, but we had reached the 100-limit in the free license. We then purchased the Professional license because EasyChair help page said the Pro ...
-4
votes
0answers
18 views

Creating website for client [on hold]

I want to create website for client in php, client already had his own domain, what is the procedure to design website for his domain ? should i have to transfer his domain to my ac or by setting ...
0
votes
0answers
13 views

Order query() by dates using the format Mon/D/YY (Apr/13/19)

I'm importing data from a sheet that uses the Mon/D/YY date format (Apr/13/19). When I try to sort the entries chronologically with the following request, they're instead sorted alphabetically (A is ...
0
votes
0answers
15 views

Import range function in Google sheet

I am facing a difficulty when I use import range function in Google sheet to combine all data in a Master file from separated many different Google sheets. It works well while using import range ...
-1
votes
1answer
18 views

Google Sheets Two-Way Databinding?

I want to make a spreadsheet in Google Sheets with a user friendly editable front end and a back end with an arbitrary number of rows containing the data to be displayed. There should be a dropdown on ...
1
vote
1answer
16 views

Selecting row with best value for items with several versions/upgrades

I'm sure my problem is quite simple to solve, but I've been on it for a while and I could use some help. I have a huge table, but the problem boils down to this: some items have 2 versions (one ...
-1
votes
0answers
13 views

Google Sheets QUERY()| Use text from cell as QUERY() array range reference

Basically, I am trying to use the text from a cell as the range reference (array using squiggly brackets) in a QUERY() function. I have two formulas created to accomplish a SUM function: The QUERY()...
0
votes
0answers
1 view

Google Spreadsheet: A replacement for Excel Camera Function

I'm getting into Google Spreadsheet after using Excel only for years. While I'm happy with it, there are some parts of Excel I haven't been able to replace. One of those is the Excel Camera function. ...
1
vote
1answer
9 views

Autopopulate a RANGE of Cells from one sheet (tab) to another in a single workbook

All I want to do is have cells in one sheet (tab) in a workbook auto-populate with data and formatting of a different sheet (tab) in the same workbook. I know how to do this one cell at a time, BUT is ...
-1
votes
0answers
12 views

Trying to find link info and info on online purchase item/service info [closed]

Trying to find out what this online purchase is, and link or site it was purchased from. It reads " debit card purchase happykeymall 6-25 shanghai 3777" on my bank statement. Top statement on pic
0
votes
2answers
12 views

How can I group by one column to join values in multiple rows?

Let's say I have a survey of people in teams, and what fruits they like: User | Team | Fruits ---------------------- Dave | Mine | Banana, Apple Steve | Mine | Apple, Orange Matt | Yours | ...
0
votes
5answers
21 views

Layperson's grid to normalized table

Introduction  (too long, don't read) I have a data-arrangement problem. I'm now up to three qualifying files from coworkers, and for that matter, I've run into a couple of questions here on SE ...
0
votes
0answers
15 views

Can I sync the scrollbars of two different windows? [migrated]

Problem In Windows, I have two Mozilla Firefox windows side by side on a screen. Right now I am scrolling through two different output logs to see the difference in the logs. Question Is there a ...
0
votes
0answers
16 views

LightnCandy not found [on hold]

I've a problem with the class "LightnCandy" and the MediaWiki Extension "Collection". Everytime I click on "Download als PDF", I become a Internal Error like this: "[...]/includes/TemplateParser.php: ...
0
votes
0answers
10 views

How can I retrieve coordinates from both a double click waypoint and a places waypoint - Google Maps API [migrated]

I am trying to retrieve latitude and longitude the same way for both the double click waypoint and the Places Search Box waypoint. I do already get the coordinates from the double click waypoint, but ...
2
votes
1answer
59 views

Enabling 2FA on a Google Account, how to get TOTP secret?

I am trying to enable two-factor authentication (2FA) on a Google account, but I'm running into a dead end trying to activate it. I'm using an up-to-date Firefox browser. When I try to enable 2FA, ...
-1
votes
1answer
28 views

Friends of friends commenting on pictures

I tagged a friend in a picture but it’s now being commented on by people I don’t know. Is there a way to ensure only the intended audience can see it?
0
votes
1answer
18 views

Google Sheet - Convert hyperlinks to buttons

In Google Sheets, I have a column of active hyperlinks. When you hover over one of them, a tool tip appears that contains an "open link" icon that you can click on to open the URL in a new tab. In ...
0
votes
0answers
15 views

Online PDFs Help [closed]

Earlier this year I clicked on a link which loaded a online hosted pdf which could have been downloaded. Unfortunately, this pdf has since been removed by the company, but included information which ...
0
votes
1answer
16 views

How to run multiple OnEdit scripts in the same sheet?

I am using an auto-timestamp script in Google Sheets. Where when you input something in a particular cell, the script will automatically add a timestamp in a particular cell. But the problem is that I ...
-1
votes
0answers
38 views

Gmail add-on Creation [closed]

How do i create an add-on for gmail that allows me to store the information in a email such as the subject and body of he email and send it to an external source to store as either a note or task ...
-1
votes
0answers
34 views

IFTTT cannot connect to Instagram

I tried several IFTTT applets. All that do somthing with instagram don´t work. The connection can´t be made. I get the error message 101/0 i am lead to instagram - i give IFTTT the permission and ...
0
votes
0answers
31 views

some company mails add EXT when I send email from my account and when reply emails are not added to thread

I am not sure how to write a good title to sum up the issue, but basically, I have lots of emails exchange with a specific company (they're using Exchange) when I send them emails, my emails come ...
0
votes
0answers
14 views

One script for multiple tabs in one Google sheet

Can you please help me with this script? I've tried to edit it to apply to multiple tabs the same as the original question. But I think something's amiss. :( Here's the original code and I want this ...
0
votes
1answer
19 views

Google Docs Prevent Download

I using GSuite product for my company, however we are working with outsource team. That guy will working (eg. editing) with several GDocs, GSheet file. I wanted to disable download feature on GDocs ...

15 30 50 per page