All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
1k views

Import Range of cells as per today date in another sheet

There are three columns A, B, C AND today date is in the first row of the column A means A1. I need to import these three columns date excluding date row. A2:A100, B2:B100, C2:C100 in another sheet. ...
10
votes
3answers
6k views

What are the GitHub achievements?

GitHub seems to have updated the achievements feature, so what other achievements are there? Is there a list of achievements and their unlock requirements? Didn't find any documentation and post about ...
0
votes
2answers
21k views

How to clear search history at Hotmail?

I have an email account on hotmail.com. I have searched a few words, using the left search bar, to find something in my emails. However, when I click on the search bar now, I still see those words, ...
0
votes
0answers
54 views

Yahoo! Mail being moved from inbox to trash folder automatically

Messages received into my Yahoo Inbox once read only stay for a few minutes before disappearing into the Trash folder. I have no filters set.
0
votes
1answer
21k views

How can I turn off unwanted labels without losing street names in satellite view?

I want to view my hometown in satellite mode, with street names only - I don't want labels for local restaurants, gas stations, pubs et cetera obscuring my view. If I turn off labels, I lose the ...
0
votes
1answer
8 views
1
vote
1answer
18 views

How to copy column but repeat cell content in new column

I stumped on how to copy a column with unique cell contents into another column but with repeated N entries of each row with Google Sheets. In sheet 1: A1:A A2:AA A3:AAC A4:AACQ A5:AAIC A6:AAL ...
0
votes
1answer
18 views

Minimum value across multiple rows, conditionally formatted

I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it. Here's specific situation: I've successfully got formatting for minimum across ...
0
votes
1answer
44 views

Script to search my Google Sheets for a partial text match in a cell and if it contains a match then clear or delete entire cell

I thought this would be more simple and easy to find online, but I'm having a difficult time so I'll try here first. I'm Looking for a script to search my Google Sheets for a partial text match in a ...
-1
votes
1answer
15 views

I'm attempting to link a Master sheet with a Google Form for clock in/out hours. How would I do this?

I'm attempting to add hours to each person by having them submit a Google Form, which will display their ID and time logged into a linked sheet(This is done). I then need the hours to be filtered by ...
0
votes
2answers
105 views

Countifs with index match and importrange

I have two worksheets https://docs.google.com/spreadsheets/d/141IcRU2RE_WmBGK4bMOI-_zyz1-hwU1TTylfbBz2pIE/edit?usp=sharing https://docs.google.com/spreadsheets/d/...
1
vote
1answer
5k views

Running multiple onEdit scripts

I am trying to run all three of these in any order but only the third runs: 1. function onEdit(){ var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var editedCell = sh....
0
votes
1answer
13 views

Google Sheets IF formula

Have a sheet where B column is "purchase date". C column is a drop down that can be "Weekly" or "Monthly". D column either 7 or 30 days from B column depending on what is ...
0
votes
1answer
63 views

Google Sheets - How to get row index for a form submission (new vs update response) [closed]

OBJECTIVE Create booking system using Google form, sheets and calendar; There is one calendar for each room; the code and the sample data is based on room#41. When there is a new submission, calendar ...
0
votes
0answers
19 views

How can I build a Predictive Model (analysis)? [closed]

https://docs.google.com/spreadsheets/d/1K2Hm1GGLPtjl327zaQdhQbIPOspIgloQZ5Elv8eai4A/edit?usp=drivesdk In the above spreadsheet...I have imported table containing daily state lotteries results from a ...
1
vote
1answer
115 views

Trying to pull Duplicate data from multiple columns

https://docs.google.com/spreadsheets/d/1VSiKZbD_PoQTfbav7spalkyBgrt4T8juaLlKOM7LgLM/edit#gid=0 I have two columns, A and B. Throughout this project, the same name will appear in each column. I want ...
0
votes
1answer
300 views

What is counted as “photo” instead of “drive” in Google's storage?

I use the "original quality" option in Google Photos. Most of the photos were added via Google Drive folder (as files). Recent photos from phone added via Photos Android app (they also visible on ...
0
votes
1answer
51 views

Change my name in the list of guests for a specific event in Google Calendar

How could I change my name in the list of guests for a specific event in Google Calendar? For example, right now I participate in an event where everyone is marked by name and surname and I am marked ...
1
vote
1answer
2k views

How to view full results for a Facebook Messenger poll

I created a poll in a Messenger chat group and I need to see who voted for the roles they are able to do, but I can only see two avatars and a +2 more. Is there any way to see all the votes? I'm using ...
1
vote
1answer
965 views

Print emails from a specific person in Gmail

I have emails from Mr. A in my Gmail account. Is there any way to print all emails from Mr. A without opening his email one by one?
0
votes
0answers
26 views

google sheets get stock in specific currency

To track stocks I made an overview of bought and sold stocks, and generate a pivot table with the current amount of stocks owned. I want to calculate the total value of my stocks. The problem I have ...
1
vote
2answers
2k views

Using Google Sheets to bulk collect the number of Google Search results for given keywords

I would like to create a Google Sheets that will allow me to paste in a list of 25 or so keywords in column A and would then return the number of search results for each of those terms in column B. ...
-1
votes
0answers
5 views

Quiz/survey website which can embedd javascript

I would like to conduct a survey where participants first play a very short (~1 minute) "game" I've made and then answer a bunch of questions regarding their experince. Is there a survey ...
0
votes
1answer
26 views

Google SpreadSheets query: how to join “grouped by” cells in a list?

Suppose I have this table: | Name | Amount | Category | | name_1 | 10 | A | | name_2 | 2 | B | | name_3 | 3 | B | | name_4 | 6 | C | Thanks to this ...
0
votes
0answers
10 views

Use another email. This one is someone's personal Google Account

I am testing Google Workspace, however, I already have a Google Drive account for my business email, so I have like myname@mydomain.com which I use to log in to Google Drive. Trying to register to ...
0
votes
1answer
14 views

Apply custom formula across all columns using Array Formula

I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
3
votes
2answers
558 views

Find web page(s) that links to a specific page in Google Search

I got an article from some page, I don't know which. Is there some Google search way of finding the parent page? Say for example from page A I navigated to page B. Page B is a PDF document. How to ...
0
votes
1answer
477 views

Google Sheets Conditional Formula

Google Sheets formula for outputting PASS or FAIL in one cell based on the color (green or red) of another cell?
0
votes
1answer
2k views

How can I drag an active cell to the last column on Google Sheets?

When I say drag I mean using the small blue square in the bottom right corner.
0
votes
0answers
11 views

The tweets I liked on Twitter disappeared

After deactivating my twitter account, I reactivated it several days later. (I already did that in the past) But this time I have a problem, indeed the tweets that I liked (those that appear in my ...
0
votes
0answers
6 views

Can you see GitHub repository's transfer history/trace?

I transferred my git repo on GitHub from usera/myapp to userb/myapp. Here I mean from transferring, I wanted to be anonymous as possible as I could, didn't want to let people know the repo userb/myapp ...
3
votes
2answers
569 views

Direct link to Gmail Compose in full screen mode

I want to bookmark direct link to GMail compose page in full screen mode. The current link I found https://mail.google.com/mail/u/0/#inbox?compose=new opens it but I have to press full screen button ...
5
votes
3answers
10k views

Is there a way to lock or protect conditional formatting in Google Sheets?

I have several columns that indicate the current state of a project task. When I complete some task (for example), I copy the "complete" text from some other cell and paste it in the new cell to avoid ...
0
votes
1answer
83 views

Google Docs new blank document has default indent from left margin

I'm looking for help with Google Docs. Every time I begin a new document, the left margin or indent markers are indented before I even start typing. This means that I end up with my text away from ...
0
votes
7answers
4k views

No way to go to end of document in Google Docs

I use Ubuntu 16.04 and Dell Latitude E7450 and just pressing End doesn't do it. Ctrl + End doesn't do it. In fact there is no way to go to the bottom of a Google Drive document. They just won't let me....
0
votes
1answer
24 views

How to create Column Identifiers in Google Sheets?

I'm confused by Google's documentation where it states: Columns are referenced by the identifiers (not by labels). For example, in a Google Spreadsheet, column identifiers are the one or two ...
1
vote
1answer
323 views

Dividing one column by another based on values on other columns and getting the sum

In the following image, what I'm trying to do is to find a formula that will divide values on column C by values on column L, ONLY IF: Value on column D = "L", and Value on column J = "Right", and ...
0
votes
0answers
12 views

change the order of gmail filters [duplicate]

Is there any way that I can specify the order of gmail filters? A simple and concrete example: suppose that I have defined 3 gmail filters, F1, F2, F3. But I did not define them all at the same time, ...
0
votes
0answers
7 views

Return a COUNT of goal completions this month *excluding today*

I'm trying to create a calculated field that adjusts our daily goal target for the remaining days in the month. My logic is: ((overall daily target * # of days in the month) - goal completions *...
-1
votes
0answers
5 views

Java Grade 12 Questions [closed]

Define a linked list of ‘player’ called ‘Team’. A. Create a constructor for player(String x, int g, int a, player p). The name is initialized to x, while goals is initialized to g and assists are ...
0
votes
0answers
4 views

How to give access to myself from one calendar to another?

I have company google account and my personal google acount. Both has calendars. I can't switch between them all the time. I want all my events be accessible from one places. How can I allow one ...
1
vote
2answers
274 views

Is it possibile to concatenate with bidimensional arrayformula?

I have a table like this: +----------+----------+----------+----------+ | Photo1-1 | Photo1-2 | Photo1-3 | | +----------+----------+----------+----------+ | Photo2-1 | Photo2-2 | | ...
0
votes
1answer
84 views

create a Telegram group through code

Is it possible to create, programmatically, a Telegram group (using my user Id)? I have a scenario where we want to deploy tool instances, per customer, and have the tool automatically create the ...
0
votes
1answer
85 views

How to send myself information from work without revealing my personal account

At work we heavily use Gmail and Drive, and there are some emails and files I would like to somehow store or send myself to store and remember at my personal account. However, I fear simply sending ...
0
votes
0answers
9 views

How can i synchronize each audio file with each picture when clicking a picture [closed]

Hello everyone i want to make a type of memories quiz that you click it then the picture show up and you have to click the other picture that has the same image as well, below here is the how can i ...
0
votes
0answers
6 views

Where do you get templates for creating a unique project [closed]

I often need templates for my project. I do not like ready-made so I like to create them myself. To do this, I use one excellent site, where I can easily create the type of templates that I need, but ...
0
votes
2answers
330 views

How to calculate the average of values in Col. B, if Col. A contains a unique timevalue of Col. C?

This is how my table looks: (in column A) (in Column B) (in Column C should be) (in Column D should be) 2016-01-01 08:00:00 80 08:00:00 240 2016-01-...
12
votes
4answers
18k views

How can I set a label on all cards in a particular list at once in Trello?

I have a board with several lists. Three of the lists are "big tasks", "medium tasks", and "small tasks". I want to make all of the cards on each of these lists a particular color. That way, when I ...
0
votes
1answer
127 views

Several KML's in one layer

I have 10 KML simple tracking route files. I have created a map with 10 layers and placed them all in a separate layer. Then I moved to Google Maps (not Google My Maps) I was expecting to open current ...
0
votes
0answers
4 views

Help in Creating a dashboard(Like the video below) using React js that contains a sidebar that includes items that the user can order to fill [closed]

link to see how it work on youtube: https://www.youtube.com/watch?v=ItnM8JzP_I8&ab_channel=eliiehachem I want to create a dashboard like this (Using React) contains a box(this sidebar looks like ...

15 30 50 per page
1
3 4
5
6 7
634