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

learn more… | top users | synonyms (2)

2
votes
1answer
524 views

How get last added text from column into different sheet

How can I get the last added plain text from a column in sheet1, which also has empty rows, into a cell of a sheet2? With help I managed to do this with the last added date, but with plain text I am ...
2
votes
1answer
149 views

In a Google Sheets chart how do I prevent “Other” in the legend?

When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
2
votes
1answer
1k views

Calculate monthly sum() on pivote table

I have a Google Form. Upon submit following fields are populated: Timestamp Product Description Unit Price Quanitity I have generated a pivot table from this data, in a Google Spreadsheet. The ...
2
votes
1answer
294 views

google spreadsheet question about data linking between sheets

Here is my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgmD6-Z4d2aVdE9pR095OTJrVE1wS3FIZzZpVFRJMmc#gid=4 What I want to happen is I enter data in the sheets marked Head, Neck, Shoulders ...
2
votes
1answer
3k views

Google spreadsheet sync with gCalendar

I create a GTD system based on excel, whose link I report here. The advantage of having this gtd is that I can share it with my european colleagues without the need of having a dedicated software ...
2
votes
1answer
1k views

Sorting a protected range in Google spreadsheets

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting. It works just perfect with my permissions as the owner, but when ...
2
votes
1answer
678 views

In Google Docs, how to make a column with several numbers in each cell sortable?

I am making an expenses spreadsheet in Google Docs and I need to list the numbers of the attachments for each entry. Sometimes this is just one number, sometimes it is several. I can make this ...
2
votes
1answer
739 views

Pre-populate Google Docs form field with incremental value

I have a Google Docs spreadsheet that I use to track my jobs by job number. Is it possible to have the "job number" field pre-populated with the next job number? Currently I have to open the ...
2
votes
1answer
581 views

In Google Spreadsheets how do I restrict input when the number of entries for a condition are met?

I am using a Google spreadsheet to gather the Registration form entries for our tournament. We can only have 10 teams per age group. How do I "close" the Registration when the number of entries for ...
2
votes
1answer
457 views

Text conditionals in Google Spreadsheets

I want to write a formula where I can add values to a cell whether another cell states approves the "transaction". It will be easier to explain with an example. Consider a spreadsheet containing the ...
2
votes
2answers
1k views

How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?

I would like to colour the background of a row in Google Spreadsheets: For example: If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black. If cell Dx = title '...
2
votes
1answer
1k views

Is it possible to add conditional formatting when number changes?

This is probably not possible but... I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings) So when the number in a cell is changed, ...
2
votes
1answer
2k views

Transfer cell value to another cell by clicking on a button in Google Spreadsheet

I want a user to be able to click on a button and have the value of one cell go into another cell. How can I do this?
2
votes
2answers
2k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
2
votes
2answers
607 views

Allow users to use my online spreadsheet in Google Docs without saving their edits

I made an online spreadsheet in to calculate grades. I want my users to use it without Google Docs showing it real-time to other users. How do I do this? It seems if I allow people to edit the ...
2
votes
1answer
1k views

Bring data from Google Spreadsheet to Google Documents

Is there anyway to read the data from a Google Spreadsheet (which I owh) to another Google Document, something like specifying a data source in MS Word?
2
votes
1answer
557 views

Send Google spreadsheet with embedded HTML in Gmail

When I try to publish content from Google Spreadsheet, it puts it into an HTML iframe. This is found under File > Publish to Web. How can I send this iframe content in a mail, sent over Gmail?
2
votes
1answer
175 views

Update a cell based on two matching fields in separate tabs within a range

I'm trying to update a cell in Google Spreadsheets where its value comes from another sheet and based on the date range entered with it. Here is what the two worksheets look like in the file. ...
2
votes
1answer
716 views

Embed interactive google spreadsheet with calculations still intact

Is it possible to embed a google spreadsheet into a webpage and keep all the calculations still intact? For example: I'd like to embed a calculator I have into a webpage, and allow the user to still ...
2
votes
1answer
982 views

How to get data between tabs in Google Spreadsheets

is it possible to get a value from a tab cell and work with it in another tab? Tab 1 (T1) row working hours (A) who (B) 1 3 Mike ------------------------------- Tab 2 (T2) ...
2
votes
1answer
3k views

Google Docs Spreadsheet - Copy data from previous sheet

HI I have a spreadsheet document where I register tournament results with a sheet for each tournament date. I want to have a cumulative column where to show cumulative information. I have already ...
2
votes
1answer
890 views

How can I charts based on day and month using dates in google spreadsheet?

I have a Google spreadsheet that has values like 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
2
votes
1answer
578 views

How can I make tabs show in Google Spreadsheet?

I copy code from an editor into a Google Spreadsheet cell. Unfortunately, it left-aligns the code making it hard to read. However, when I double-click on it to edit it, the tabs are still there (...
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?
2
votes
1answer
19 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" ...
2
votes
2answers
23 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
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 ...
2
votes
1answer
48 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 ...
2
votes
1answer
15 views

Autoincrement a date in a formula when dragging horizontally

I have a date in column A, and a formula in column B that references the date. I'm trying to drag the formula over to 6 more cells horizontally, representing the 7 days of the week, Column A being ...
2
votes
0answers
27 views

What is the behavior when Zapier matches more than one row?

Zapier has a Lookup Spreadsheet Row - action. The docs say "Lookup Spreadsheet Row - Finds a row by a column and value. Returns all the values on that matching row." What is the behavior if the ...
2
votes
1answer
22 views

Easily switch between seeing only lines affecting a running total and all lines

Background: I have a spreadsheet with one row per date. Each row has a current total A, there are different ways to either add or subtract an value from that total. No other column except G (for A, ...
2
votes
1answer
63 views

How to select multiple, non-consecutive cells in Google Sheets using a list of the cell addresses

I have a very long, comma-separated list of cell address coordinates, shortened here for the sake of brevity: C3,C7,C17,C56. I would like to select these cells. Is this possible to do by pasting the ...
2
votes
1answer
19 views

Set global “export to PDF” settings for Google Drive Sheets

I'm an Aussie. Google Drive is obviously built for USA first. Each time I export a Google Drive Sheet as a PDF, I have to change the page size from Letter to A4, and other such settings. Is there a ...
2
votes
1answer
35 views

Selecting a single column from all rows for chart range

I want to specify a certain column from all rows (omitting the first few) to be the range for my chart. Currently I input this to specify the range: L6:L (note: this automatically changes to L6:L20 ...
2
votes
0answers
29 views

Updating/merging rows from imported data that share the same primary key in Google Sheets [duplicate]

I'm using an IMPORTDATA function tied to a auto-running script to pull in a .TSV data file from an obscure webform system. That all works well, and I'm able to generate a nice dashboard from this data....
2
votes
0answers
24 views

Map Chart using decimal degrees in Google Sheets

I have a column with decimal degrees (locations) and another one with values. Can I plot a Map Chart on Google Sheets (with markers)? If I have to use the Script Editor, any existing (working) snippet?...
2
votes
0answers
22 views

Coordinates of an external named reference

In a spreadsheet, I've got a column named range: Sheet1!I:I, named NamedRanged1. In another sheet, I'd like to get the index of that named range, i.e., 9 (I is 9th column). I tried with ADDRESS and ...
2
votes
1answer
30 views

How to list which values from field A don't appear in field B? (Survey recipient responses)

I have a weekly survey I send out to the same list of people using Google Forms, and they populate a 'responses' spreadsheet. I delete the responses weekly, and new rows are added as new responses are ...
2
votes
0answers
11 views

Avoid redundancy in formula in Google Sheet [duplicate]

Say I have a long expression (i.e. with a lot of characters) expr. I want to give a cell the formula =if(expr>10,expr,0) (this is an example, the condition could also be =if(iserror(expr),expr,0)). ...
2
votes
0answers
49 views

Google Sheets <copy Data from one spreadsheet to another>

Could you help me to understand how to made next couple: Table M Table 1 Name -> Name Qty <- Qty Table M has original field Name, Table 1 takes this name and ...
2
votes
0answers
12 views

Is it possible to import cell data AND cell format from one Google sheet to another? [duplicate]

I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format. Suggestions?
2
votes
0answers
37 views

In Google Sheets is it possible to print to a custom paper size?

I have a spreadsheet that I'd like to print on a single 8.5" x 22" sheet of paper. This is not a standard paper size, but my printer can print on it. The Google Sheets print settings dialog only ...
2
votes
2answers
287 views

“Incorrect range height” error in Google script when using setValues

I am trying to convert calendar dates to fiscal dates. I've been successfully able to do all that. My problem is trying to write the fiscal date values back into the spreadsheet. Here is the code: ...
2
votes
0answers
78 views

Google Sheets - Dynamic Filter View by URI

I am using Google Forms to acquire "per-X" feedback, and want to dynamically produce customised reports that are filtered based on the URI. What I am looking to achieve is a unique URI per X that ...
2
votes
0answers
16 views

Splitting Multiple Multi Line Cells into new rows [duplicate]

I am working on employee data and the data I have received comes with two cells (Proj Name and Count of Hours) which have multiple names/ hours in the same cell separated by line breaks. I have ...
2
votes
0answers
34 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
2
votes
1answer
119 views

Formula to use in Google sheets to count all cells containing specific texts

Here is a link to a sample spreadsheet: https://docs.google.com/spreadsheets/d/1LcfqPxsnQGEVZKd2imM1WPYRvgbZBiEQ18mHVd3znjE/edit?usp=sharing What I want to do is count all unique values in column C (...
2
votes
1answer
220 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 ...
2
votes
2answers
21 views

Added rows in Google Sheets missing formula

I have made a simple formula, based on cells in the same row, to indicate to the user that they have entered enough information—and it works as needed. =IF(AND(ISTEXT(B20),ISNUMBER(C20),ISNUMBER(E20),...
2
votes
0answers
56 views

Run two timestamps for time in/out in one Google Sheets [closed]

I have this code: function function1(event) { var timezone = "GMT-8"; var timestamp_format = "hh:mm:ss a"; var updateColName = "Agent"; var timeStampColName = "Start Time"; var sheet = ...