A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

0
votes
0answers
61 views

Intermittent Google service connection failures

This is something of a follow-up to my other question, Gmail chat not working after power outage. This is a short summary of what happened there: Computer turned off without warning because power ...
1
vote
1answer
13 views

Importrange All Sheets

Is there anyway to call an IMPORTRANGE() and have it include all sheets? Here is my current function that combines the current data with the first archive, I'd like to set it up as a failsafe for the ...
0
votes
1answer
18 views

How to set up email notifications to specific accounts when a field is changed?

If a field is is changed in a row I need an email to be sent to the email that corresponds with the row. For instance say in a row the first field is 1234@gmail.com, the second is a description field ...
0
votes
1answer
9 views

Conditional Formatting Referencing another Cell (and using addition)

I am tracking high school credit acquisition. Each trimester a student must earn 2 credits to remain on track. If Cell A1 is "trimester 1 total credits", and cell B1 is "trimester 2 total credits", I ...
1
vote
1answer
25 views

Transposing Column to Row

I am trying to write a script that will transpose a column from one sheet into a row on another sheet. I have already figured out how to do the copy, but I need to figure out how to change the data ...
0
votes
0answers
11 views

Moving Column in Google Sheets

I am trying to create a script in google sheets that will go through each column and if there is data, copy it to a different sheet and then check the next column for data. If there is no data I want ...
0
votes
0answers
13 views

Google Sheet: How to make 'fixed row' cells a sort button for whole column?

Basically i have fixed column with column headings like Name | Email | Profession | Age | Gender I want to be able to click name, age, etc and have all rows sorted based on that column in alphabetic ...
0
votes
1answer
16 views

How to copy the contents of a single cell from one Google spreadsheet to another Google Speadsheet?

I am trying to copy the content of one cell of a Google speadsheet to another cell in a different Google spreadsheet. I have tried the formula (=Exportrange("spreadsheet-key", "Sheet-name! range")) ...
-1
votes
0answers
16 views

Google Spreadsheet/Excel formula for calculating shipping expenses of my orders [closed]

I have Website form that is entering data in Google Spreadsheet and I need to calculate automatically by Google Spreadsheet formula Shipping Cost for all orders. Data consists of: Name Email Online ...
2
votes
1answer
19 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...
1
vote
1answer
31 views

Paste value only without formula for hyperlinks

Consider the following: A | B | C ------------------ | -------- | ------------------- =HYPERLINK(C2, B2) | Google | http://google.com =HYPERLINK(C3, B3) | Facebook | http://...
2
votes
2answers
22 views

Update the reference in Indirect() when new columns are added

I have a a very large spreadsheet that pulls data from another logsheet through an Indirect depending on user input on cell A1. =INDIRECT($A$1&" Data!$AG$3") I'm trying to add some new columns ...
2
votes
1answer
12 views

Getting the highest values for each day

I have a bunch of raw data in a spreadsheet - dozens of temperature readings a day. My ultimate goal is to graph the highs and lows of each day, filtering out all the other readings. So my data ...
0
votes
0answers
50 views

Tally duration, client, client category in each Google sheets Timesheet

I use Google Sheets for my time sheets, using the following folder structure: Timesheets Corporate CorpClient1 Timesheet (Drive Sheet) CorpClient2 Timesheet (Drive Sheet) Freelance ...
2
votes
1answer
17 views

Lookup formula returns an incorrect answer

I've written a Google Sheets formula that looks like this: =lookup(I6, {"First", "Second", "Third", "Forth", "Fifth"}, {((D6-E6)*H6), (0.43*H6), ((D6-0.25-E6)*H6), ((D6-E6)*H6), ((D6-E6)*H6)}) ...
-2
votes
0answers
15 views

Google Sheets Android App [migrated]

I have been trying to incorporate conditional formatting to change a negative number in a cell to red. I am not seeing the conditional formatting panels as described in several different sites. If I ...
1
vote
1answer
9 views

Conditional formatting for a single cell based on a row being empty or containing any values

I want A1 to go green if any cells in range B1:J1 contain any values. A1 to remain blank if B1:J1 contain no values. In the sheet all values will be text based but will vary from cell to cell.
-1
votes
0answers
12 views

How to include Split function in Query

I have asked a similar question here: https://productforums.google.com/forum/#!topic/docs/TO80Cpz_agQ;context-place=mydiscussions I managed to work a different solution answered in that post. I ...
0
votes
0answers
13 views

Capture the time of issue resolution [duplicate]

I need help in understanding how to capture a timestamp of a particular entry in the google spreadsheet. My team is working on customer issues and I would like to capture the time of issue ...
1
vote
1answer
14 views

Filter last result before a specific date

I've got the following formula working. However, I need only the last result, but at the moment it is returning more than one result. =IFERROR(FILTER(MAX(FORM!$Q$3:$Q,FORM!$N$3:$N<$A$1,FORM!$O$3:$...
2
votes
2answers
39 views

Search for a value in all Google Spreadsheets at once

I have hundreds of spreadsheets in Google Drive and I am trying to find a value in one of the files. For example, I need to find all sheets that have a $1000 value, but I don't want to open each one ...
5
votes
1answer
42 views

Can I add the URL from a Facebook status update to a Google Spreadsheet with IFTTT

Would it be possible to save the actual URL where you can find the individual post to a new row in a Google Spreadsheet from Facebook to Google Drive Spreadsheets? (You can get to the FB status URL ...
1
vote
1answer
17 views

Get the latest specific date prior to today

I am using the Google Analytics Add-On for Google Spreadsheets, and need to get data for the financial year to date. I have the finish date set as: =TODAY() Which is working fine. Now I need to ...
0
votes
1answer
23 views

Restrict the range of a script that replaces input data to a certain range

There is this question regarding adding checkbox functionality to Google Drive: Checkbox function to automatically add to total. And a great answer is: In the Google Sheets spreadsheet go to Tools ...
1
vote
1answer
16 views

How to update row in Spreadsheet based on respective cell value?

I'm about 10 days new to coding in GScripts/Spreadsheets and I've been struggling to write a Spreadsheet function that will change the values of certain cells in certain rows depending on the value of ...
2
votes
1answer
28 views

Create a sparkline for the delta between each column of data

Lets say I have data like so... A B C D E 50 100 125 175 225 I want to create a sparkline that will show the difference between each column SPARKLINE( [B-A, C-B, D-C, E-D])...
3
votes
1answer
26 views

Conditional formatting based on data “age”

I have a sheet of figures, numbers as values. I was wondering if there was a way to have a cell automatically change colors based upon either: Change colors based upon how long it has been since the ...
0
votes
1answer
21 views

Compare date value to current date in Google Sheets

How can I compare the date in a row to a current date, so that if it's greater than today the next steps in my process need to be executed?
0
votes
1answer
14 views

Generating multiple random numbers in a single cell

I am attempting to create a sheet that reads a cell and generates a set of random numbers based on that cell's length I have a long list of one to four random numbers, in the format below. 4 2 2 0 4 ...
1
vote
1answer
14 views

How can I change the value of one cell in Google sheets based on what is entered into another?

Using Google Sheets, I have a dropdown list of different actions, and each action has a different score associated with it. Eg. Action a = 5 points, Action b = 7 points etc How I can make Google ...
1
vote
0answers
11 views

Auto populate a field with the user who made the change

This is what I use to allow Google Sheets to auto-populate the date/time in column "N" whenever any cell in that row is updated. function onEdit() { var s = SpreadsheetApp.getActiveSheet(); var ...
2
votes
1answer
16 views

Display results when a string is not in a range

On this worksheet I am trying to see if the data in column B is not in the lookup list in column C. If the data from column B is not there, then I want to print the respective value from column A. I ...
0
votes
1answer
11 views

Populate a cell with a different cell when selecting from a drop down

I have a drop down with the following: Bin Run, Single Clean, Single Clean Bagged. I want to populate Cell G41 With contents from cell I18 when my dropdown says "Bin Run". I have this formula as ...
0
votes
1answer
23 views

How can I link cells from one sheet to another sheet and keep formatting and comments?

I'm a teacher and I'm trying to set up a spreadsheet with students' grades that will link to an individual spreadsheet with the header from spreadsheet#1 plus the row that has an individual's grades. ...
1
vote
0answers
21 views

How to automatically sort a filtered list that's always changing in Google Sheets?

I have a complex spreadsheet that rolls up data from all over the place into a filtered list. We need to sort this filtered list, along with notes added afterward in columns to the right of the filter....
2
votes
1answer
15 views

Why is a blank string greater than 0 in Google Spreadsheets?

Why does ="" > 0 Evaluate to TRUE? And how can I input a value that would evaluate to FALSE that is not a number?
2
votes
1answer
38 views

Copy submitted form data to new automatically generated Google sheet

I have created a new sheet for every new name entered in the form using the following code. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; SpreadsheetApp.getActiveSpreadsheet()....
2
votes
1answer
23 views

QUERY most recent date prior to today

I have list of dates in column R that are spaced by two week intervals, so 6/1/16, 6/15/16, 6/29/16, etc. In columns S to AF I will mark "y" or "n" each day on the row corresponding to the date, ...
1
vote
1answer
15 views

Querying multiple ranges from form responses to new sheet

Recently, someone on this forum put together a formula for me. It works on a sheet pulling responses from a google form. I'm trying to model a new one after that but I'm having trouble. The working ...
2
votes
1answer
35 views

Auto-create and name new sheet in Google sheets from names being filled from a google form

How can I automatically create and name new sheets in a google spreadsheet from a list of name which are being input in the sheet from a google form.I would like each new sheet to be created when a ...
3
votes
5answers
66 views

Apply formula to a numeric part of cell value

In a Google Spreadsheet, I have a column with values like T1, T2, T13 (i.e. all values starting with the same text prefix). I would like to use a formula on the numerical part of the values of these ...
0
votes
2answers
36 views

Google Sheets, Conditional Formatting, Negative Numbers

What I'm doing in Google Sheets I have cell A1 with a value 10. I have cell A2 with value -11 and cell A3 with value 11 . I want to conditionally format cells so that when their value is less than -$...
-2
votes
0answers
5 views

Apply formula to a numeric part of cell value [duplicate]

In a Google Spreadsheet, I have a column of task IDs, with values like T1, T2, T13 (i.e. all values starting with the same text). I would like to use a formula on the values of these cells (for ...
-1
votes
1answer
48 views

Getting e-mail adresses using a filter in Google Sheets /w scripts

I am trying to extra email replies from gmail. I already found some code that is supposed to work. My question is: how can one expand it to support a filter as a variable? (in this case so a filter ...
3
votes
2answers
44 views

Data Validation: how to ensure all columns have unique data within the column

I finally found this answer which tells how to use data validation to make sure all the values in one column are unique. But it doesn't tell if there is a way to write a single validation rule that ...
0
votes
0answers
30 views

Is there such a thing as a “git blame” for Google sheets

I know that one can easily see the revision history of a Google Sheet. But then that's the same as running git log.. It shows shows a chronological order of changes to the file. I'm actually ...
4
votes
2answers
54 views

Count occurrences of names so that only one in each row counts

I have a set of data in one Sheet tab, and a counter on another tab in the same document. I want the counter (in sheet 2) to read through the text in the table in sheet 1, and update how many times ...
1
vote
1answer
15 views

Filter numbers in one column based on whether they are higher than in another column

How to filter numerical data in column B based on whether or not the number is higher than the number in column A?
0
votes
2answers
30 views

Track highest number in a cell over a series of recalculations

How do I keep track of the highest number that was in a cell in Google Sheets? I'm running random numbers through a cell and I would like to track the highest number reached. Specifically, I am ...
0
votes
0answers
23 views

Create dynamic form with data from a spreadsheet

I'm trying to create a form that collects the questions from a spreadsheet dynamically. Example Table: Name Number Age Don yes no Andy no yes Marry yes yes The ...