One of productivity apps in Google Drive, that allows you to create and edit worksheets

learn more… | top users | synonyms (1)

1
vote
1answer
24 views

Auto-Import Master Spreadsheet

I'm fairly new to Google Spreadsheets and completely useless when it comes to functions and formulas. Is there a way to take info from multiple sheets within a workbook and compile them into a ...
0
votes
0answers
27 views

Google Forms: Add numeric values and use them for billing in paypal on form submission

I am using a google form to let people signup for a conference that lasts 3 days. A user has options to pay for a day, 2 days or the full conference. He/she has the option whether or not to pay for ...
0
votes
0answers
38 views

How to convert data submitted from a google form to number type keeping the responses spreadsheet formatting

I have a google form where one clicks an option from a list of options. The options are 400, 500 and 0. When I submit the form I want to perform calculations on this data but I'm getting an error, ...
0
votes
0answers
8 views

Google Spreadsheet to open another Google Spreadsheet populated

What I would like is to click on a name in a cell in one spreadsheet and it will populate a new spreadsheet giving the title in ascending order such as A001 next time you click it it will populate a ...
0
votes
1answer
37 views

Using VLOOKUP with dynamic range array

I have a sheet with a list of email address that is being auto-updated (more email addresses being added on a daily basis). I have a second sheet with a list of email addresses that have been ...
0
votes
1answer
52 views

How to format the date in this Google Docs script

I've come across this rank checking script. I'm not sure exactly where I found it but it's built on Google Docs and a script which automates the rank checking process. I understand a bit of coding ...
1
vote
1answer
54 views

How do you automatically align incoming form responses in Google Sheets?

I like to have each of my form responses aligned in the center of their cells. However when I submit any new information through Google Forms, they are always automatically aligned to the left, and so ...
-1
votes
1answer
35 views

How do I eliminate extra line breaks in a google spreadsheet cell?

I have a google doc in which some cells have multiple carriage returns. I would like to eliminate all the extras, so that 4 carriage returns shrinks down to just one. This question is similar to How ...
1
vote
1answer
29 views

Preventing Paste Overwriting Cell Formatting in Google Sheets

I have a spreadsheet used for booking employees onto training sessions. It's very simple to use; the person booking simply enters their employee number into column A and column B, C & D ...
1
vote
0answers
17 views

Google Sheets Cells don't calculate when printed or viewing as PDF

Workbook: Very large workbook with multiple tabs of data and multiple tabs of reports using sumproduct, query and filter formulas. Payroll tab is a reflection of our master database so i'm not dead ...
1
vote
0answers
27 views

Send email from Google Spreadsheet to adress in column

From an existing Google Spreadsheet; every time a value is added in column M(x), I would like to send an email with a specified text to the address listed in column F(x) from the same row x. Which ...
0
votes
0answers
64 views

How would I use Google App Script to create a ListBox based on a spreadsheet entry?

Every month I receive a spreadsheet with tickets available with its code, expiration date and type. Code | Expiration Date | Type (3d or normal) ... ... ... ... ...
1
vote
1answer
62 views

How to make a protected range appear normal in Google spreadsheets

I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. ...
2
votes
0answers
52 views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
1
vote
1answer
48 views

Google spreadsheets showing “shared with xxx” count greater than actual?

For every one of my Google spreadsheets, the sharing settings is on "Specific people can access", and each sheet is shared with 3 people I know. Their names are listed when I click on the blue "Share" ...
0
votes
1answer
22 views

List of range from another spreadsheet

I have two spreadsheets, The first sheet has a list of data companies company A company B comapny C In the second sheet i need to create a drop down menu to fetch the companies from the first ...
0
votes
2answers
34 views

Rename Column in Google Spreadsheets

Does anyone know how to rename a column in google spreadsheets? Seems easy enough in excel. https://productforums.google.com/forum/#!topic/docs/ewnE52j57YU I was hoping that ideally I could see what ...
1
vote
2answers
54 views

How can I select a sheet with a variable-supplied suffix in a script?

Here is the code I'm attempting: var day=new Date().getDay()-1; var month=new Date().getMonth(); var sheet=ss.getSheetByName((/^.\s/+month+'/'+day)); I'm new to regex, but essentially I'm writing a ...
0
votes
1answer
30 views

How do I move a Google Spreadsheet document from one Google account to another?

I created a moderately complex Google Spreadsheet document in my personal account, which become popular amongst my colleagues and is now officially adopted by our team. Therefore, it would make sense ...
-1
votes
1answer
78 views

ImportHTML spreadsheet function to update every 5 mins

I have a Google spreadsheet fetching stock exchange data using an ImportHTML function: =ImportHtml("http://www.xxxx.xx.xx/xxxxxxxx/livefeedfull.aspx/?"& year(now()) & month(now()) & ...
2
votes
3answers
68 views

Can I make a sheet private in a Google Drive spreadsheet?

I have a Google Drive spreadsheet with multiple sheets. The first sheet pulls data from all the other sheets. I need to share the first sheet with all users. But I only want to share the rest of the ...
1
vote
2answers
400 views

How do I get linked Google spreadsheets to auto-update when 'I am not looking'

My question is similar to this one, for which no answer has yet been posted. How can I get Google Sheets to auto-update a reference to another sheet? I am filling one Google Spreadsheet with Zapier ...
1
vote
2answers
46 views

Is it possible to prevent people from entering data into my Google Spreadsheet?

Is it possible that I fix the order of user's entries with a script? For example, the user must fill cell A1 first, only after that he can fill cell A2. Maybe my explanation is better with an ...
1
vote
1answer
17 views

Set Selection throughout all sheets

I have a spreadsheet with multiple sheets. I want them all to scroll in sync. For example if I scroll to J18 in Sheet1, all others sheets will have the cursor at J18 and same row/column at the top ...
0
votes
0answers
26 views

Can't figure out how to import data from particular website

I want to import the top 25 QQQ holdings from the following page into Google spreadsheet. I want to import both the "Equity View and Equity Price" tabs. Im not sure the info is listed in a table as I ...
0
votes
0answers
24 views

Google Sheet Script: “=ImportFeed” does not run if spreadsheet opened by a background script (time-driven trigger)

I have a "History" sheet which will forever store anything that has ever been in the feed and a "Feed" sheet for the current imported feed (i.e. it just contains =ImportFeed) This Google Script runs ...
0
votes
2answers
26 views

Conditional Formatting for Google Spreadsheets

I have created a Google spreadsheet. It has actual values and calculated values. I want the background to be green if the calculated value is less than the actual value and red if it is more. ...
1
vote
2answers
41 views

How can I prevent users from reverting to an old version of a Google Spreadsheet?

I would like to allow users to edit a Google Spreadsheet, but not be able to revert them to prior versions. Is this at all possible? USE CASE The spreadsheet we use keeps track of snacks consumed, so ...
1
vote
1answer
68 views

How do I sum all even or odd columns in Google Spreadsheets?

The following is given as a solution for Excel: =SUM(IF(MOD(COLUMN(B16:AO16),2)=0,B16:AO16,0)) =0 changes to =1 to toggle between odd and even columns. However, this doesn't work in Google ...
0
votes
1answer
58 views

Retrieve last entry via ImportXML

Looking for help pulling specific cells from a web site into a Google Spreadsheet. I want to pull "last" price from this page but only a few specific ones. Such as Dow, Nasdaq 100, S&P 500, ...
0
votes
3answers
57 views

How to calculate average screen reso. based on number of visitors using a spreadsheet?

I want to find out what the average screen resolution is for visitors to my website – or rather, what is the average width and the average height in pixels. To qualify what I mean by "average" – and ...
0
votes
1answer
48 views

Conditional counts based on dates

I am creating a master tracker for all the technology in my school and it is pulling data from many sheets and placing it in to blocks and I am having trouble figuring out the following ...
0
votes
1answer
35 views

How to match info between tabs in a Google spreadsheet

How can I take info from one tab and add it to another? For example, I have Tab 1 with column A—call it “cat breeds”—and I have Tab 2 with column A—call it “cat breeds”—as well. They need to match so ...
2
votes
1answer
28 views

How can I reference a cell in a custom function while setting up data validation in Google spreadsheets?

I made the following Google script to check whether a string is less than some length: function isLengthLessThan(length, text) { return (text.length < length) }; How can I set up data ...
3
votes
2answers
155 views

Single drop down with data from separate columns

I have a spreadsheet that I need to add new data to but the previous user made it so that I can't add data in a new row without moving down a lot of data which would mess with all the calculations. ...
3
votes
2answers
63 views

Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)

I'm compiling a database of business address info, including key staff for each business. The Google spreadsheet I've inherited for this project includes a column for 'key staff' (in column B), with ...
2
votes
1answer
45 views

Is there a way to neatly format length in Google Spreadsheets across multiple orders of magnitude?

I have a spreadsheet with a column for length with values ranging from millions of kilometers to fractions of micrometers. Viewing it all in meters as unformatted numbers directly is awkward since you ...
0
votes
2answers
30 views

Which formula sums all values from a column in a line that contains a specific word?

Let's use this random spreadsheet to illustrate my problem. What I want to do is a sum of all Page Views (F) that contains the Category (B) named /Online Computers. Which formula can I use to do ...
1
vote
0answers
36 views

Yet Another Mail Merge - sending to multiple recipients

I'm required to send a parametrized mail message to multiple recipients, based on values in a Google spreadsheet. I've followed the instructions in this guide on how to use Yet Another Mail Merge. ...
0
votes
0answers
50 views

Google spreadsheet disappearing text

Whenever I enter text into a box and press enter the text disappears. I can only view the text by clicking on the box it's in. What am i doing wrong? Windows 8, Firefox 29. It only occurs in firefox. ...
1
vote
2answers
40 views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
1
vote
1answer
32 views

Add a sheet from a template

Is there a way to add a new sheet to a spreadsheet from a template? If I'm using a template for time, I'd like to add a new sheet from the same template every two weeks.
2
votes
1answer
42 views

Appending text to each column in a Google Drive Spreadsheet

I have a Google Drive spreadsheet that has about 200 columns. Each one is a name, and to each one I want to append -banner.jpg. Is there a way to batch process this? For example: abcde fghij ...
1
vote
1answer
44 views

How to share only one tab in the new Google Spreadsheets?

I have a Google spreadsheet with two tabs. First one is a public one where I want to invite specific customers to edit it. Second one is just for my team and I would like it to be invisible to the ...
0
votes
1answer
45 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
0
votes
0answers
32 views

Getting error while using a Google Forms/Spreadsheets Auto-Increment Script

Similar to Kelly's problem here: Can I add an autoincrement field to a Google Spreadsheet based on a Google Form? I need to create a unique ID upon submission of a form which will be used as a case ...
2
votes
0answers
48 views

Can't unmerge cells

I have a lot of data in a Google spreadsheet that depends on charts I spent ages trying to make look pretty. There is a stupid block of merged cells that won't unmerge, and when I try to ...
-1
votes
1answer
20 views

How can I get a column with the sum of the proceeding rows from another column?

I've got a series of withdrawals and deposits for an account, each in a row. I'd like another column that for each row, displays the total amount in the account after that row's withdrawal or deposit. ...
1
vote
1answer
71 views

Error with exact date 21/02/1971 - function MINUS expects number values

I am getting this really bizarre error. In cell A1 I have 21/02/1971 (Brazilian-style date), in A2 I have =today()-A1. I receive the following error: #VALUE! Error: Function MINUS parameter 2 ...
2
votes
1answer
24 views

Google Spreadsheets SUMIFS with Text Value of Cells

Is there a way to use the text value of cells with a conditional statement such as sumifs so that on one sheet I can have all the expenses # A B C 1 R. Tusk Travel ...