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

learn more… | top users | synonyms (1)

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 ...
0
votes
0answers
63 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
51 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
46 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
33 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
50 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
29 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
74 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
66 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
348 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
22 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
24 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
63 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
46 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
154 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
35 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
49 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
39 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
37 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
0answers
39 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
31 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 ...
1
vote
0answers
43 views

Can't unmerge cells

I have a lot of data on 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 cut'n'paste ...
-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
70 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 ...
0
votes
0answers
16 views

Create email with google script with google fonts

I've created various scripts to automatically send email to users who submit a form. no I'd like to touch them up a bit by using a specific Google Font (Philosopher). Here is the script I tried ...
1
vote
2answers
117 views

How can I easily fill a column in Google Spreadsheet with random values from a list?

I need to create some data for a simulation. So I wanted to take a spreadsheet, and for each column, fill it with random data falling within a domain. A uniform distribution is good enough. For a ...
0
votes
1answer
31 views

Link a range of vertically ordered rows, to a horizontal range of columns

Is there a range function in Google Spreadsheets where I can link the values of SheetA!A1:A10 to SheetB!A1:J1? So basically rotating the values from rows to columns.
0
votes
0answers
24 views

How can I add new row value to mentioned column in the sheet which has multiple columns with unequal lenght?

I have three columns in spreadsheet with unequal row length. For example, Column A has 5 row, column B has 7 rows and column C has 2 rows. When I wanted to add for example column A with the AddRow ...
0
votes
2answers
54 views

Google spreadsheets - How to calculate a value based on the row/col number of another cell value

I am trying to build a spreadsheet that one sheet holds a list of names divided into groups. The second sheet, should list all the names, sorted, with a number next to each name according to a ...
0
votes
1answer
52 views

Publish single google spreadsheet to the web

I have many sheets in one spreadsheet, how do I publish single spreadsheet to the web? When I attempt to publish, it doesn't show any option to pick the sheets I want to publish.
1
vote
1answer
115 views

Send an email with attachment using Google Apps Script

I have a Google Spreadsheet with a list of emails. I want to build a routine that send email automatically to those email addresses. I also want to attach a PDF to this email. The PDF file is located ...
0
votes
0answers
38 views

Google Spreadsheet not refreshing correctly

I have a single sheet (see the sheet Data: AEX) that loads data using the importdata function (4 columns). All following columns contain formulas based on the imported data, some formulas share a ...
2
votes
1answer
48 views

What is the fastest way to use Google Spreadsheets by several users - from the same account or from different accounts?

Terminology - I use spreadsheet for a document and sheet for a sheet within the document. TL; DR If several users must work on data, stemming from the same source, which is fastest: one Google ...
0
votes
0answers
22 views

Dynamic drop down in case of multiple cells for looking specific list of subsequent cells and choosing

How to use a dropdown in case of multiple cells in case of large data which I have posted at > https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/O5oKD2Afkp0 And Spreadsheet > ...
2
votes
2answers
57 views

Formula required for date and counting fabrics

How do create a formula that counts the days I am waiting for fabric to arrive, however when it does arrive I need it to stop counting the days. =TODAY()-TO_DATE(A41) This works great, however it ...