All Questions

0
votes
1answer
10 views

How can I conditionally format cells to denote past/future/current dates?

I have a church rota Google Sheet. Column A shows the date of each service. To make it more obvious at a glance, I would like cells in column A to apply formatting so that dates in the past are ...
0
votes
1answer
44 views
+50

Is it possible to batch create or template Gmail filters?

I tend to create many filters in Gmail so that lots of types of email I receive daily doesn't interrupt me with new mail notifications, but instead gets assigned a certain label (kind of like how ...
1
vote
0answers
20 views

Is it possible to save driving directions in Google Maps?

I am using Google Maps to plan a road trip. One of the issues I have is that I would like to create a set of (maps? directions?), one for each day. A daily trip would start at an address (a hotel) ...
-2
votes
0answers
14 views

I am a group owner but cannot edit a display name [closed]

I am a group owner but cannot edit a display name.
0
votes
0answers
14 views

Bot telegram that copies and forwards messages from a chat or group?

I don't know if it's the right community so if I'm wrong, tell me where I should write ... However I would like to know if there are any telegram bots that automatically copy and forward messages in ...
1
vote
1answer
20 views

Problem inserting a column and cell reference/link

I have a sort of summary in my Google sheet. In the second column, I refer to the sub tables further in the sheet with e.g. this content: https://docs.google.com/spreadsheets/d/1J- ...
2
votes
1answer
41 views

Recovery of Discarded Draft [closed]

Suddenly in discarded, all of my Drafts... Is it possible to recover them somehow?
0
votes
1answer
30 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? [closed]

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
28 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 ...
0
votes
1answer
11 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
33 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
16 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
1answer
18 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
12 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
25 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
11 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
12 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
8 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
18 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
24 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
427 views

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
22 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
10 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 ...
0
votes
0answers
15 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
17 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
22 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
16 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
6 views

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
11 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 ...
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
27 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
17 views

LightnCandy not found [closed]

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
98 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
32 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
21 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
1answer
21 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
37 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
37 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
18 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 ...

15 30 50 per page