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

learn more… | top users | synonyms (2)

3
votes
1answer
30 views

Transpose only one column in Google Spreadsheets

I have a sheet like this: I want it to have two columns: in and out with the corresponding values: I'm able to do so using sorting and copy-pasting, but as the data gets more complicated this ...
0
votes
1answer
18 views

Why do I receive a Parse Error code when trying to multiply two numbers?

In B1 I have 248.2. In B5 I have -2. I want to calculate the weight loss percentage. However when I enter =(B5/B1)x100 I receive a Parse Error. What am I doing wrong?
1
vote
0answers
14 views

Use indirect in ARRAYFORMULA for multiple ranges

I have =ARRAYFORMULA({indirect(B2);indirect(B3)}) whereas B2 = Sheet1!a1:a8 and B3 = Sheet2!a1:a8. I want something like this: =ARRAYFORMULA({indirect(B4)}) whereas B4 contains B2 and B3: Sheet1!...
2
votes
1answer
35 views

Script to insert new row and copy down formulas that auto increase according to row index?

I am trying to create a menu driven script that will insert a new row at the end of a sheet and copy down all formulas - with it auto increasing according to row index. This is what I have so far but ...
1
vote
1answer
28 views

How to enter a date in Google Spreadsheet without hyphens or slashes

Is there any way to enter a date in a Google Spreadsheet without having to type hyphens or slashes?
1
vote
2answers
14 views

Google Spreadscheet COUNTIF in ARRAYFORMULA

I'm trying to make a work/project overview, but I'm stuck. Hope you guys can help me out. The countif formula checks for how much times the criteria is the same. As you can see in the image, Gregor ...
0
votes
1answer
16 views

How to make Query() not break with empty cells

I'm trying to perform a query through an imported range, but whenever I have an empty cell in the first column, it gives me a cell that is a combination of ALL of the cells that have an empty Col1 at ...
5
votes
1answer
33 views

How to insert a named-range of spreadsheet cells into Google Slides

Google Slides has the ability to insert a chart object (Google-sheets). This instance in the slide can be dynamically updated each time the source-chart is changed. Chart insertion is performed by ...
-1
votes
0answers
20 views

In Google Sheets - need a script or function to automatically update all files in drive folder

I run a comic book store that offers a subscription service and use google sheets for the "pull list" as it allows customers to alter their subscription titles from their home. Each month, the list ...
0
votes
0answers
25 views

Format a cell if the person has not signed in by certain time of day

I have a sign-in sheet where attendees sign-in for their cases. I want to write conditional formatting for the cell to turn red if they have not signed in by 8:45am on the current date - so two ...
-1
votes
0answers
26 views

Problem with script to keep daily record in Google sheets

I'm turning to these forums after a long search on my problem but have not been able to find any solutions. I am trying to create a sheet on google sheets that keeps a record of data from another ...
0
votes
0answers
17 views

How do I perform a calculation on a column whenever a new sheet is uploaded to Google sheets

I'd like to do a simple calculation everytime a new sheet is uploaded to a folder in Google sheets. The calculation should be automated so the script will recognize a new file and will go to a ...
1
vote
1answer
29 views

Auto insert column with today's date every day

I would like Google Sheets to insert a new column between columns A and B at the start of each new day with that day's date in cell B1. Is there a function or script that would make this possible?
1
vote
0answers
19 views

Improving performance by removing cols and rows in Spreadsheets?

Does it save local memory and thus improve performance if one either hides or deletes unnecessary (i.e. empty) rows and columns from spreadsheets?
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
17 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
26 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
17 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
18 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
21 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
34 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
25 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
13 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
18 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
14 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
17 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
22 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
1answer
15 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
23 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
16 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?