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

learn more… | top users | synonyms (2)

2
votes
1answer
6 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 ...
0
votes
1answer
12 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
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 ...
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 ...
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 ...
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
12 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 ...
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
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
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 ...
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 (...
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....
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/...
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 ...
1
vote
1answer
14 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,...
-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 ...
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 ...
-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 ...
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' ...
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 ...
-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 ...
3
votes
0answers
9 views

Getting a sum of cells (bottom to top) in Google Sheets until a specific value is matched

I'd like to sum up values of specific cells in a column (In this case column A) from bottom to top, in order to get the latest added values, until they match a specific value (if greater than zero) ...
1
vote
1answer
7 views

Formula referencing the last column in sheet

Each week I add a new column to a spreadsheet and then need to update several formulas to calculate the delta between the last column and the column to the left of it. I haven't figured out a way ...
-1
votes
0answers
5 views

How to timestamp a row for changes made to specific columns?

Auto-updating column in Google Spreadsheet showing last modify date I found this post very useful in creating a date stamp, however I am very new to script (meaning this is my first time working with ...
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....
0
votes
1answer
9 views

Embed Google Doc within a Google Spreadsheet

Is it possible to have a big spreadsheet with many sheets and have one sheet that has an embedded Google Doc? This would allow me to use the Google Spreadsheet as a dashboard and individually ...
1
vote
1answer
14 views

Conditional Formatting if all cells fail to meet a certain criteria

This is the spreadsheet I'm working on. I am trying to figure out a formula for conditional formatting so that it only highlights the cells in red if none of the cells from columns N to Y of the ...
0
votes
1answer
17 views

Need help with regular expressions

I'm new to using regular expressions and I'm trying to use REGEXEXTRACT to pull info from a larger text string into separate cells: Men's T-Shirt (Amount: 6.00 USD, Qty: 1, Size: M, Color: Black) I'...
3
votes
1answer
13 views

Nesting a Function Within a Logical Statement in Google Sheets

Is it possible to include a formula as the value_if_true within a logical statement in a cell in Google sheets? For instance, I would like to subtract the two rightmost digits in two adjacent cells, ...
4
votes
1answer
46 views

How to use “split text to columns” when pasting in Google Sheets?

I have some CSV data in the clipboard that I'm trying to paste into a Google sheet (Chrome, Windows 7). There isn't really a direct paste option for CSV data (like the "Paste Unformatted Text" option ...
3
votes
1answer
10 views

Comparing values in two different columns, detecting those that are also present in the second

I have two columns I'd like to compare data in. The first column has about 50 rows, whereas the second column has 200 rows. I would like to be able to tell if any cell in the first column matches up ...
2
votes
1answer
12 views

Is there a constant to represent “last row of a column” in Google Spreadsheet?

I have a function like this in Google Spreadsheet: SUM(A10:A500) I'm using 500, but if it's possible I want to use a constant that represents end of the column A (i.e., the last row of a column ...
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
13 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
32 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
27 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
0answers
28 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
19 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
24 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
25 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
16 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?
2
votes
0answers
15 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?