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

learn more… | top users | synonyms (2)

2
votes
1answer
5 views

Splitting up comma separated values in a single cell to new rows

Every night, we run a batch that sends data from a point of sale service that sends data to Google Sheets, with the hope that we can trigger a Mailchimp automation or add subscribers (the POS software ...
1
vote
1answer
348 views

How to display Image from URL in Google Sheets? (and apply it to multiple rows)

So I created a list of members in Google Sheets, each member having a profile image, name, location, etc. I exported this list from import.io, a data extraction tool. The only problem is that when I ...
0
votes
1answer
10 views

Highlight two numbers if they are different

So I have a sheet that requires me to confirm if two numbers in different columns are the same and would highlight them if they are different. The two numbers are always One row and column apart, so ...
1
vote
1answer
10 views

Using MEDIAN with INDEX/MATCH pair to pick the row where a given number falls in between two values

I need to match a text field to a source number. That’s easy I thought… The complication appears to be that the ‘search number’ is in a single column array (many hundreds deep) and the ‘Lookup array’ ...
1
vote
1answer
10 views

Line chart with the number of tickets created by date

Here's what my sheet looks like: I'm trying to create a Line chart with 3 lines showing the number of tickets we get that labeled 1) billing, 2) info or 3) troubleshooting by date. So I want the ...
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 ...
1
vote
1answer
28 views

Combining columns horizontally with an arrayformula

I need to join columns with a formula (not a script) in Google Sheets in a different way than others I've found--here is my original data, supposing that the Avengers train by playing racquetball: ...
1
vote
0answers
7 views

Formatting time duration “d, hh:mm” to display correctly when positive and negative

I use Google Sheets for my timesheets. I enter time I start working, time I end and duration of break. Daily time spent is then being calculated (i.e. column D). That all works. But then I have the ...
3
votes
2answers
73 views

Coloring cells according to the value to which its content is closest

I am trying to make a guide for my dragons on a game I play but I'm not quite sure how to code what I am trying to do. Link ex. if has values "Guardian"(C2:C100) and "Dragoness"(I2:I100) in its row ...
3
votes
2answers
48 views

How can I sort in Google Sheets by cells containing section (or version) numbers?

I'm indexing a document with sections and sub-sections. I want to have one column representing the section-number and be able to sort by this column. However when the sub-section gets higher than 10, ...
-1
votes
0answers
12 views

Automating a number of actions on Google Sheets (multiple linear regression)

I need to carry out a multiple linear regression on a certain range of cells and would like the output from the regression to update automatically any time this range of cells is changed. Here's a ...
2
votes
1answer
12 views

Export images from formulas in Google Sheets

I have a Google Sheet that has a column generating images (barcodes in this case) based off of data from other cells via the =image(url) function. I thought this would be a great way to quickly create ...
2
votes
0answers
11 views

Google sheets: chart with steps of constant height change, variable width

I want to draw a chart in Google Sheets to represent the position of a stepper motor. As the motor speeds up, it steps more quickly. But in this case, it can only ever move one step at a time. So if I ...
10
votes
2answers
21k views

How to calculate difference in hours between two time fields

I have two time-formatted cells and I need to calculate the difference (eg 10:30 PM) in hours between the two. Ie. cell 1: 10:30 AM, cell 2: 1:15 PM. Simply =B1-A1 will not do the trick.
3
votes
1answer
63 views

Highlight/reject cells that contain any of the values from another sheet

I have a sheet/tab that contains nothing but a single column where each row is a word, let's call it wordlist. In another sheet/tab, I would like to make it so that for one of the columns, if the ...
2
votes
1answer
116 views

How to show instead of hide repeated values in pivot table?

By standard, repeated values in pivot table are only shown once. I made an example sheet to illustrate: This becomes a problem for people who use filters over pivot tables: Notice how Donald's ...
2
votes
1answer
188 views

Auto Sort data in Google sheet, but by sheet not range

I have found this script from this question to auto sort a column: How can I apply a script to only one specific sheet within a spreadsheet function onEdit(){ var sh0 = SpreadsheetApp....
0
votes
0answers
7 views

How to auto-sort when date is entered in specific column

I have a Google Spreadsheet in which I have column B as date (header) column. I want that once I enter the date and move to next cell it auto-sorts the data based on that column.
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
0answers
6 views

Google Sheet Run Google Analytics Report from button?

I have a Google Sheet that is using the Google Analytics plugin. I have a page in the sheet that pulls data from the Google Analytics results to present it to a customer. On this page are the dates ...
1
vote
1answer
2k views

Conditional formatting with if formula

On Google Spreadsheet, I want cell D88 to change background color depending on the value in E88. In my head this should work like this (imagine it's a conditional formatting window): =if(E88="yes")...
1
vote
1answer
15 views

VLOOKUP problem with value from =arrayformula(iferror(regexextract

I'm trying to use VLOOKUP to pull data from one tab in a Google Sheets workbook into another tab. The VLOOKUP formula works if the value being searched for is 100103, but not the cell reference G2 (...
0
votes
0answers
14 views

Google Sheets: Script to add protection and remove the user running it?

We've been trying random solutions for the past couple of weeks that we have found on here and other sites.. came close a couple of times but still no bueno. Scenario: We have a worksheet that will ...
0
votes
1answer
5 views

Google Sheets registering blank cell as zero

I am writing a formula into google sheets and I do not want the formula to register a blank cell as zero. The formula is: =ARRAYFORMULA(MIN(IF(A:A=H12, (D:D-C:C)))) It keeps giving me a zero value ...
2
votes
1answer
17 views

autoincrement in Google Sheets based on Google Form submission

I'm trying to create an auto-generated unique ID# for each meetings being submitted via a Google Form. The unique ID# solution must also meet the following requirements. The ID# must be static (...
1
vote
2answers
40 views

Google Sheets formula for “if contains”

I'm trying to figure out how to identify 'if' a list of items in one cell contains a value or string. EXAMPLE Cell A1 contains "sites, sheets, docs, slides". I want cell B1 to display a 1 'if' ...
2
votes
1answer
13 views

Copy a column with mixed currencies using Google Apps Script

I have a google spreadsheet tab that needs to be copied to another sheet. In most columns I can set the formatting to the proper currency formatting, so when copying the column, the format is kept and ...
0
votes
0answers
5 views

Removing “Sent Via…” Text from Emails generated from a Google Spreadsheet Mail Merge Script

I found a spreadsheet script http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/ that I use with Google Sheets that allows me to send out emails, pulling personalized elements from ...
-3
votes
1answer
15 views

ParseError on spreadsheets

I am receiving a "Parse Error" on this function: =loadBlueprints("corp",4324234,"7okqZ1gOyG43243243242342qb2wkyd21C",90926985) this turns out to be a parse Error though i do not see where it may be....
-1
votes
0answers
7 views

Google Sheets: Find the most recent Time Stamp of a specific item when there are multiple entries per item [duplicate]

I am trying to document the days a car was cleaned and return specific data about the cleaned car (e.g., something is broken, location, etc.). So, I want each car to report the most recent cleaning by ...
0
votes
0answers
15 views

Direct link to a copy of Google sheet without asking user to “Make a copy”

There is a method to prompt (or force) users to make a copy of a Spreadsheet. For example, say this is the Spreadsheet: https://docs.google.com/spreadsheets/d/...
1
vote
1answer
30 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
1
vote
1answer
13 views

How can I get a Google spreadsheet cell or range reference dynamically?

I can explicitly reference cell G42 or range A42:G42. But what if I need something dynamic? For example: I want to write an expression in cell G200, which would calculate the average of cells A42:G42,...
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
27 views

Update latest spend on Google Sheets based on Date dimension

I have a spreadsheet report -- used to monitor our marketing campaign reports. So my goal here is to be able to update a cell showing the our current spending as of yesterday. How can I go about ...
0
votes
1answer
37 views

Is there a script to draw a list of variables from a table to Google Forms?

I would like to have a field in Google Forms that allows the user to select a value from a "List" of values. The options in the list being drawn from a list in the sheet itself. This allows me to add ...
0
votes
1answer
26 views

How to allow users to enter some data in Google Sheet without actually modifying the content?

I'd like to make a sort of calculator based on a grid, where the user checks different lines/columns and it will calculate some stuff based on what's checked. Perhaps I could do something in HTML/...
2
votes
1answer
219 views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
3
votes
2answers
287 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
5
votes
1answer
58 views

FILTER function in non-continuous sections

I have seen similar questions asked but have not found a good working solution. I have a spreadsheet which has two sections which need to be filtered into a separate tab. The first column is names, ...
-3
votes
0answers
23 views

How do I get the use of my phone back to its original format for my lg optimus e980 [closed]

Someone has hacked my phone and I know who it is even though they lie to me about it. I have apps that run constantly and that persists on runimf and I'm sharing the net with someone and I can't get ...
2
votes
1answer
46 views

Google Forms - Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
3
votes
1answer
347 views

Is GOOGLETOURNAMENT defunct?

I do not follow the NCAA Division I Basketball Championship but am interested in the accuracy of current advice re Google Spreadsheets. One of the functions is GOOGLETOURNAMENT which, rumour has it, ...
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
0answers
18 views

Google Sheets: Find the most recent Time Stamp of a specific item when there are multiple entries per item

I am trying to document the days a car was cleaned and return specific data about the cleaned car (ie something is broken, location, etc). So, I want each car to report the most recent cleaning by ...
0
votes
1answer
19 views

Convert the data from comma-separated cells into repeated rows

I have a Google Spreadsheet where the first column is multi-valued (not all rows though) and also a few other columns. Not all columns are multi-valued. The values are separated by ',' Here is an ...
2
votes
1answer
32 views

Is there a way to get the summary section from a form into a Google Doc

I've got a survey using Google Forms and it has useful graphs in it's summary section (under responses). How can I get these graphs into a Google Doc? I tried downloading the CSV file and recreating ...
-1
votes
0answers
14 views

Query from google spreadsheet: display on new lines ( char(10) )

I need to make queries from a google spreadsheet of specific cells that contain multiple values, each one displayed on a separate line using the command char(10). In the spreadsheet, the values are ...
4
votes
3answers
4k views

Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)

I have a Google spreadsheet that builds Google Analytics links. I'd like to shorten those links. I tried the Bit.ly example but even their example does not work. How can I do this?
1
vote
1answer
10 views

Google sheets: My timesheet is a pre-filled list of dates for the whole year How can I get quickly to today's date?

Or at least, to the last entry I made? remember - i may enter my hours on last friday, but the sheet already has next monday's date pre-filled, so ctrl/end doesn't work. the year goes to March 2017....