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

learn more… | top users | synonyms (2)

2
votes
1answer
605 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
663 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 ...
3
votes
3answers
4k views

Google Spreadsheets: Excluding Negative Values

Is there a way to get a function to return any result below 0 as 0 or not include negative numbers in sums? I'm using it to track my total overtime through the year at work. So right now I have it so ...
3
votes
1answer
223 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 ...
1
vote
0answers
548 views

How to protect table cells in Google Spreadsheets from myself (accidental edits)?

As in Microsoft Excel, I want to protect certain cells in Google Spreadsheet. This is possible, but asides from the fact that it is quite confusing to me, it doesn't seem possible to protect cells ...
1
vote
1answer
377 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
1
vote
1answer
10k views

How do I automatically update a cell in Google Spreadsheets to the most recently entered in the same row?

I am trying to have one column that will show the most recent thing i entered in the row. Example: I want B2 to be the same as D2 but once I enter something in E2 I want B2 to display that. And then ...
3
votes
2answers
2k views

Google spreadsheet: named range built upon formula

I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7), B2's formula is something like =COUNTA(A1:A10000). That way if I add some value in cell A8, the count ...
1
vote
1answer
281 views

Count related to date items in a Google spreadsheet

I have a spreadsheet that shows how many are still completing a task at two and 8 weeks. Col A Name Col B has Start a date Col C is the WeekNumber of the date from col A (Using WeekNumber Script) ...
1
vote
2answers
266 views

Finding and removing periods in Google Spreadsheet

I'm using a Google Spreadsheet and trying to create a formula to remove a period and anything that comes before it in a cell. For example: idontwantthis.iwantthis I have used this in the past: ...
0
votes
1answer
397 views

Google Spreadsheet won't display the leading space in the cell

For following graph, the Google Spreadsheet won't display the leading space before android:xxx. How could I enable it or how could I add a leading space ? <set ...
1
vote
2answers
583 views

Google sheet: sort value according to another column

I'm a total n00b to this, so I'll try to explain the best I can. I have a Google Spreadsheet prepared: example sheet In column I, I want to list every player in column B if the value in column C is ...
2
votes
1answer
2k views

How do I disable Google Spreadsheet comment notifications?

I've got a shared document with a co-worker and they're adding comments. The system keeps sending me emails with every comment she adds and it's rather tiresome. Google Support says there should be a ...
2
votes
1answer
793 views

Copy one Google Spreadsheet to another

I am developing a Google spreadsheet that I want to make publicly accessible to a community. I've released the first version of it, and now everybody in the community has that first version's link ...
1
vote
3answers
206 views

Google Spreadsheets: how to show the 10 most recent rows from another sheet's timestamp?

In one sheet A I have an ongoing number of rows where the 1st column is a timestamp in ascending order (more recent entries at the bottom). I'd like to have another sheet B where only the 10 most ...
0
votes
1answer
1k views

Embed Google / Microsoft Excel spreadsheet [closed]

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsoft Excel web app and Google spreadsheets, but none of them ...
3
votes
1answer
868 views

Single Response Spreadsheet (with multiple sheets) from multiple forms

I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response ...
8
votes
2answers
6k views

How Do I Create a Google Spreadsheet Formula to SUM data based on two variables

DATA SECTION: So I have data in one sheet like this: TYPE AMOUNT YES/NO Pig 20 Y Pig 30 N Pig 10 Y Cow 20 Y Cow 30 N Cow ...
0
votes
1answer
3k views

How do I get an onEdit script to run on a Google Spreadsheet for all users

I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited. The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
9
votes
4answers
1k views

How to copy from Google Spreadsheet without it editing the source data

Every time I copy and paste from a Google Spreadsheet, it adds a double quote before and after everything, and duplicates every single double quote. For example, if I copy: This is a "string" of ...
2
votes
1answer
4k 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
377 views

How to make a private edit on a shared Google Spreadsheet

I'd like to make some notes/mark some cells privately on a shared Google Spreadsheet in Google Drive. Is this possible?
2
votes
1answer
512 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
4answers
4k views

Google SpreadSheet conditional formatting based on number of characters

In Google Spreadsheet, is there a way to conditionally format a cell if it has more than 30 characters?
0
votes
1answer
811 views

Apply conditional formatting rules to Google spreadsheet column past set limit (10)

Limit to conditional formatting appears to be 10 per column. Any work around except creating another column next to it for those additional rules or functions, then copy/paste data from one column to ...
0
votes
1answer
2k views

Password protected online database or spreadsheet [closed]

I have a client that wants a simple online database or spreadsheet solution. Requirements Custom fields and field types (text, images) CRUD contents through a web GUI Password protected (single ...
2
votes
1answer
965 views

Date format in spreadsheet (google doc)

I want to create spreadsheets to record the money I spend each year. Each file is named as Cost-2012, Cost-2013,...etc. Inside each file, there are in fact 12 sheets, which are named as 01, 02, ..., ...
3
votes
1answer
1k views

Google Apps Spreadheet SUMPRODUCT issue

I have a table with the headings Status | Currency | Total In the rows I have a variation of statuses and currencies. Using Google Spreadsheet I added this: ...
1
vote
1answer
2k views

Sorting Google spreadsheet by month and day but not year

I made a Google spreadsheet with a list of birth dates, anniversaries, etc. that I would like to sort by when they occur in the year, not when they first happened. If you sort by the date normally, ...
3
votes
1answer
1k views

Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger

At the end of each row filled in, using a custom Google Form, I'm adding three more columns: Date of creation Unique ID QR code (it is a list of computers) Unique ID and QR code are unique. QR ...
2
votes
1answer
486 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 ...
4
votes
2answers
5k views

Get last date from a column on a different sheet

I'm looking for help on the following: How do I get the last date from a column in sheet1 returned in a cell of sheet2 I tried it with: =FILTER(Sheet1!A:A ; ROW(A:A) =MAX( FILTER(ROW(A:A) ; ...
3
votes
1answer
310 views

In Google Spreadsheets how do I put in a formula in after a transpose?

In my spreadsheet the transpose formula fills in a deliberately variable number of column cells, how do I fill in a cell after a transpose formula? I've created a youtube video to demonstrate (click ...
2
votes
0answers
985 views

Sorting on a web-published Google Spreadsheet

I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc. I would ...
1
vote
1answer
410 views

2 axis line chart in Google Spreadsheets

I've set up a Google Spreadsheet to compare one set of stats against another. The stats are for traffic vs. an action the actions only happen once a day and not every day were as the traffic has more ...
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 ...
0
votes
1answer
587 views

How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet

I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'. Problem: I need to take multiple company names ...
1
vote
1answer
118 views

Adding a few lines of information to a grid

I have made out an 8 column, 21 lines, informative health chart with grid lines. I would like to add an afterthought running from left to right UNDER the grid lines that will PRINT out with the ...
3
votes
2answers
4k views

Pull CSV data from URL to Google Spreadsheet

I have a site which allows authenticated users (read: in-house users) to download certain data from the site in CSV format, e.g. http://example.com/activities.csv . Can I create a Google Spreadsheet ...
3
votes
3answers
4k views

How to get the intersection of two sets

I have two lists (unique sets) in a spreadsheet and I want to get the intersection of the two. Is there an easy way to do this? Here's an example of what I want to achieve: List 1 List 2 ...
5
votes
2answers
6k views

Google Spreadsheets Filter() - referencing source array in criteria

The filter() function looks through a source array, and filters it according to condition =FILTER(A:A,ISNUMBER(A:A)) My source array is a rather long formula, so I end up repeating the same formula ...
2
votes
3answers
2k views

how do I get named ranges in Google Spreadsheets to be more reliable/current?

I'd like to pull values from a named range into a calculation. I have this function: function getNamedRange(n){ SpreadsheetApp.getActiveSpreadsheet().getRangeByName(n); } Seems pretty simple. I ...
2
votes
3answers
11k views

How to auto increment a field in Google Spreadsheet

In my spreadsheet I have a column called S+ No. How to auto increment this for each row, like: S1,S2,S3,S4 In short how to make it dynamic.
1
vote
2answers
820 views

Categorize cells in Google Spreadsheets

I'm using Google Spreadsheets to manage my shared expenses with my girlfriend. It looks like this: | Who | What | Category | When | Amount | | Gui13 | Vegetables | Meals | ...
5
votes
3answers
5k views

Google Spreadsheets formulas: compare each cell of two rows

I am working on a Google Doc spreadsheet using a not-so-simple formula. The formula works but is not as I want it. What I want to achieve is: "Compare each cell from T3 to AM3 to each cell from T2 ...
3
votes
1answer
3k views

How can I apply a script to only one specific sheet within a spreadsheet

I have a spreadsheet with two sheets called Robin and Lucy. I've made/found/mangled a script to sort the data on the sheet each time I add some data to column A function onEdit(event){ var sheet = ...
3
votes
1answer
1k views

How to get the average of the last four values of a row

I have a spreadsheet that looks like this. It basically tracks the ratings of each show. As you can see each row as a varying number of values. What I want to be able to do is to get the avg for ...
8
votes
1answer
908 views

How do I decimal-align numbers in Google Sheets

In Google Sheets, I want to decimal-align numbers without adding trailing zeros in the fractional part. Instead of: I want: +------+ +------+ | 56.0| | 56 | | 27.0| | 27 | | 83.0| ...
5
votes
7answers
11k views

Is there a way to link a “Choose from a list” style question in a Google Form to a list of data (e.g. in a spreadsheet)?

Would really appreciate some help from any experts in Google Forms. Is there a way to link a "Choose from a list" style question in a form to a list of data (e.g. in a spreadsheet)? This would mean ...
2
votes
3answers
2k views

how do I add isblank(ref) criteria to arrayformula?

EDIT: Self-Answered This is an improvement of work from this post. I have an array formula that is similar to this image. It sums column A when the date in F matches the due date (C). What I ...