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

learn more… | top users | synonyms (2)

2
votes
1answer
141 views

Custom Actions in Google Spreadsheet

I find that I often change specific cells from black on white to white on black when I'm making spreadsheets. It get's tedious to change the background color, then the foreground color over and over ...
2
votes
1answer
867 views

How to automatically open a created text document after it being created

I've used this script to create a Google Document (like word document) with Google Spreadsheet. But, when I do so, the new text document created from a template is placed in the default chosen folder. ...
2
votes
1answer
906 views

How to make a simple two column data chart in google spreadsheet? (simple case but doesn't seem to work)

I have a column with dates and a column with an amount of money. I just want to make the simplest chart possible, a line chart that shows money as a function of time, so I can see in what dates I tend ...
2
votes
1answer
178 views

Chart with points in Google Spreadsheets

I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
2
votes
1answer
877 views

If cell equals a value then move row to different Google Spreadsheet

I've got a script that sorts a Google Spreadsheet when a value in a column is changed. I'd like to add to the script the following functionality: If the value for column E = "Complete" then the ...
2
votes
1answer
180 views

google spreadsheets timesheet calculations

I have a timesheet that I use to log my time. It works fine if I log in and log out. It works at the end of the day but doesn't work in all configurations. For example, I want it to work if I only ...
2
votes
1answer
185 views

Creating multiple instances of a cell value in Google Spreadsheet

I have a Google Spreadsheet with the following data: A B ----------------------------- 1 | Number of responses | Value 2 | 1 1 3 | 3 ...
2
votes
1answer
164 views

Compute average over month when measurement is irregular

I want to measure my power consumption. So once in a month I note my meter reading. So I got the following data: 2012-12-01| 893.8| | |31 2013-01-05| 977.2|34|2.45|31 ...
2
votes
1answer
647 views

“Yes” if a value partially matches in a range of values, blank otherwise

I have a column of values (column A for this example) like such: Phytophora sojae Phytophora ramorum Cryptococcus neoformans Coccidioides posadasii And I'd like to create a new formula column (B) ...
2
votes
1answer
545 views

How do I reference multiple cells in one sheet in one cell in another sheet?

I am using Google Sheets and I have two sheets in one document (SHEET1 and SHEET2). I want to be able to use a formula that allows me to: If cell A1, B1, D1 and F1 in SHEET1 have an s in them Then ...
2
votes
1answer
542 views

How can I make text flow out of a cell as it does in Excel?

If you enter a long bit of text into a cell in Microsoft's Excel the text flows out of the cell over the top of the adjacent cells. This doesn't happen by default in Google Spreadsheet - it flows ...
2
votes
1answer
526 views

Enabling script to run as author in a shared Google spreadsheet

I created a spreadsheet that I'd like to share with anyone with the URL. The sheet contains several app script functions. These functions both change the content of the sheet and copy data to ...
2
votes
1answer
161 views

Statically positioned chart (ignore scroll)

I have a Google Spreadsheet with 4 columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen. Is there a way to make it static ...
2
votes
1answer
3k views

Grouping Columns in Google Spreadsheets

I have a Google Spreadsheet that has 6 or 7 columns that are all related. I would like to group them all under one header, to show this relation. Each column would additionally have its own additional ...
2
votes
1answer
480 views

Show 'sum' when multiple cells selected in Google Spreadsheet

If I select multiple cells in a Google Spreadsheet, sum or count appears at the lowerright corner according to the data type. Sum is shown for numbers, and count is shown for characters, dates or ...
2
votes
1answer
440 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
1k views

How to make a ratio win:total with only integers and least terms

So basically I am trying to find a way to show a simple ratio of wins vs total games. for example: 2 wins on 5 games would give me a ratio of 2:5 5 wins on 15 games: 1:3 8 wins on 18 ...
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
284 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
835 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
226 views

Filter function overwrites formula with '--'

I am using the filter formula below. The formula works fine the first time, but once it filters the result properly, it corrupts the same formula in next row below with --. ...
2
votes
1answer
567 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
659 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
390 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
903 views

Is there a way to insert a bookmark into a google Spreadsheet?

I know you can do this with a Google Doc, but how about a google Spreadsheet? I'd like to have a bookmark and then link into that cell of the spreadsheet from an HTML document.
2
votes
1answer
435 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
999 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
1answer
3k views

How to Send Html Emails in Google Spreadsheet

Here's an example of a Google Docs Spreadsheet script that sends emails using Google spreadsheets. I want the email Sent in HTML not plain text. Can someone help me out? function sendEmails() { var ...
2
votes
2answers
1k 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
598 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
544 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
165 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
621 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
2answers
1k views

Problem using the TRANSPOSE() function in a Google Docs' Spreadsheet

I need some help with a Google Docs spreadsheet. Let's say I've got a column and in the column I have 3 rows containing the values A, B, and C: Column: A B C I need to transpose the column so that ...
2
votes
1answer
830 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
2k 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
474 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
41 views

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

Thanks for a very useful script. Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) I am trying to do the same thing, some of my rows have only one entry and ...
2
votes
1answer
53 views

How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?

I have a filter view in Google Sheets that does not refresh when new data comes in via Google Forms. To refresh the filter view, I can remove the filter and apply it again, or even just click "OK" in ...
2
votes
0answers
12 views

Toggle named range window with a button?

I would like to know if it would be possible to toggle the different features in sheets with a script. What I am trying to do is to basically create a button that will show the Named Ranges side ...
2
votes
0answers
14 views

Is it possible to reference a cell above with an ArrayFormula? [duplicate]

Here is an example situation which I would like to achieve using ArrayFormula: Column A is the data, column B is the calculation. Here is an implementation without ArrayFormula: Here is how I ...
2
votes
2answers
36 views

Format of spreadsheet chart not kept when exporting inside my GoogleApp

I built a Table Chart in Google Sheets, and all numerical values except for the last column are displayed as percentages, which is a behaviour I need and want. View of my sheet (sample of the Table ...
2
votes
2answers
85 views

How to reference a fixed sheet name in Google Spreadsheet

I am doing reports from a set of data in Google Spreadsheet. As of now, I have several sheets, among them Raw Data and Processed Data. In my Processed Data sheet, I use formulas such as: SUM('Raw ...
2
votes
1answer
31 views

Grab text of first row of column with last data value

Essentially, I want the values in column D to be the value of the header row of the column with the last data value. For example, if H27 is the last cell with data in row 27, I want D27 to be the ...
2
votes
1answer
32 views

SUMIF using NOT ISDATE

I want to sum across a range of fields, but only if the cell contains a number, not a Date. I would love to use something like SUMIF(A2:Z2,"!ISDATE()",A2:Z2) But the criteria in SUMIF is incredibly ...
2
votes
2answers
49 views

Google Spreadsheets: Insert new rows automatically

I have two columns, one with German texts segments (in rows) and the second one with the Spanish translations of these segments. The problem is that in many cases the segments are too long for my ...