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

learn more… | top users | synonyms (2)

2
votes
1answer
46 views

Is it possible to define user permissions on a sheet basis in Google spreadsheet?

I have a Google spreadsheet with 10 sheets. Is it possible to define user permissions on a sheet basis in Google spreadsheet? For example, on sheet 1, user X can edit but user Y can only view.
2
votes
1answer
1k 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
1answer
192 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 ...
2
votes
1answer
157 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 ...
2
votes
1answer
3k 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 ...
2
votes
1answer
156 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 ...
2
votes
2answers
72 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 ...
2
votes
1answer
53 views

Google Sheets Passing Range from separate sheet into custom function

I have the following custom function I've built to basically reproduce a needle haystack type of functionality function ListBy (Range, Range2, needle) { var holder = []; if(typeof Range != ...
2
votes
1answer
765 views

Prevent “invoked too many times per second” error in Google Apps Script

I have a Google spreadsheet consisting of different months on each tab. Every month, I add a new tab and another 50-75 rows. There are many tabs. There is a cell on each row which calls a custom ...
2
votes
2answers
101 views

How to summarize many-to-one table in Google Sheets

I've got two separate sheets we'll call 'Sheet A' and 'Sheet B' with a table on each. The table on 'Sheet A' has a Many-to-one relationship to the data on the second sheet. On the second sheet, I'd ...
2
votes
1answer
415 views

How can I change Google Spreadsheets to have iso 8601 dates as default?

I would love to set my default date-setting to be iso 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date-format for a given spreadsheet by: ...
2
votes
1answer
203 views

Leads per Week For Last 10 Weeks Formula With Countif

I have a long list of dates (like below) that indicate Leads and I am trying to get number of leads per week for the last 10 weeks. I know I can get the current week number with ...
2
votes
1answer
111 views

ARRAYFORMULA and COUNTIF

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of I inputs divided by <> (all other inputs) and I need to omit blank cells. The IFERROR ...
2
votes
2answers
127 views

Return name of range as string in Google Spreadsheets

I have a range that is named apple in Google Spreadsheets. I thought a method like getRangeName("apple") would exist. I want to get the names of many ranges and set them as the header for the columns ...
2
votes
1answer
115 views

Google Sheet sum column by referencing column header

In Google Spreadsheet, I would like to find a column using a variable matching the column header and sum the column if the match is found. Example: ------------------- Ref | X | Y | z | ...
2
votes
2answers
124 views

Add new row while keeping functions in new Google Spreadsheets

In the new Google Spreadsheets, I'm trying to make a simple spreadsheet which will assign points to my salesmen regarding some actions they complete. I would like to be able to add a new row below ...
2
votes
2answers
217 views

Automating Calls to New Google Sheets Add-ons

I'm building a Google Spreadsheet that uses an official add-on to pull data from Google Analytics using the new add-on store. What I'd like to have it do is automatically refresh the data every day at ...
2
votes
1answer
53 views

Moving down the fixed page numbers in a Google spreadsheet

Can you move the page numbers on the left side of the screen down? I have a list that I need numbered, but the very top of the list (meaning the first column) has the categories for said list. So that ...
2
votes
2answers
185 views

How to write this formula “If X = Y, TRUE, else(look at this range, find the position, then ”do this")?

Since I don't know exactly the kind of function I'm looking for, be aware that maybe my terminology isn't right to describe what I need to do. I suppose that I need something close to an if/else ...
2
votes
1answer
3k views

Get cell row and column index in Google Spreadsheet

I have spreadsheet with two sheets inside. The name of the first sheet is "fr" and the name of the second sheet "cql". Now the first sheet contains data as the picture given below. And the second ...
2
votes
1answer
64 views

How to capture a cell when entered or selected?

I am trying to capture, programmatically, the on cell entered and on cell selected method, but I don't seem to be able to find any documentation on it. I can get the time stamp for exiting the cell ...
2
votes
1answer
294 views

Summing Duration Format with QUERY

I want to sum the begin and end with the QUERY function, to be able to subtract them, see table: day | begin | end | -----------------------------------| monday | 9:00:00 | ...
2
votes
1answer
203 views

Referencing cells above and to the left in script

I'm trying to make a script for a custom function in google spreadsheet to work out the hours worked in a day function hwtd(). I've got it perfect in the cell (((F8-E8)+(F9-E9))+(IF((F10<E10), ...
2
votes
1answer
807 views

Using cell reference with COUNTIFS formula

I am trying to get this formula to work =countifs(J6:J365, "=David & Victor", K6:K365, "=g3") where G3 is a date value (e.g., 02/24/14). I am trying to count the instances in my spreadsheet ...
2
votes
1answer
502 views

Can you get hyperlinks to work in a published spreadsheet?

I created a Google spreadsheet, included a link within it (using the "hyperlink" function) and then published the file to the web. It turns out that when you access it from the web, links don't work. ...
2
votes
1answer
507 views

How do I reference a cell string to use as a note in another cell?

I'm simply looking for how to link one cell's data into another cell as a note. What I have here simply errors telling me I do not have permission to setNote. :/ function noteSetter() { var ss = ...
2
votes
2answers
107 views

Altering the Sort Filter in Google Spreadsheets

I live in Australia and when I'm putting in dates, I place the date, followed by month then the year. However when I am filtering/sorting my spreadsheet it's coming up incorrectly. How do I edit ...
2
votes
1answer
401 views

Date Formatting for Deadlines

I have set up a Google spreadsheet for managing projects and due dates, and I need to apply the following formatting to a column of dates, but I'm not sure how: Dates more than 7 days from today: ...
2
votes
1answer
355 views

Google Spreadsheets: How to count items meeting criteria in multiple columns

In Google Spreadsheets I need to count instances of a certain value but only when they match either of two values in another column. So below I would ask for the count of all brown animals that are ...
2
votes
1answer
253 views

MATCH Function does not work

MATCH function does not appear to work at all. Given the following data: $7,109.19 | $867.19 | -$5,374.81 | -$11,616.81 =MATCH(MAX(FILTER(B122:U122, B122:U122 < 0)),B122:U122) returns the error ...
2
votes
1answer
517 views

How do I debug “The action you're trying to perform is causing a fatal error and cannot be performed” errors?

Since today, I'm no longer able to edit a specific Google Spreadsheet. Every time I try to make an edit, no matter which kind, an error message is displayed: The action you're trying to perform is ...
2
votes
1answer
885 views

Split content with multiple lines into multiple rows and columns in Google sheets

I like to know if it is possible to split an entire paragraph contained in a single cell, into multiple columns and paragraphs using formula's in Google sheets. This is what the text in the cell would ...
2
votes
3answers
560 views

Count the number of Fridays in a specific month

I would like to find the number of Fridays for a specific month via function in Google Spreadsheets. For example, for January 2014 the value would be 5 and for February 2014 the value would be 4. ...
2
votes
1answer
156 views

Get data from specific date in Google Spreadsheets

I’m trying to collect data from specific dates in a Google spreadsheet. For example, I want to get the data from January only. Is this possible?
2
votes
1answer
439 views

Applying IF Statement to entire column

I currently have an IF statement that checks a cell in column B if it is blank. If it is blank it returns No in the corresponding A cell. If it does have a string, it returns Yes. I currently have ...
2
votes
1answer
196 views

onEdit only updates top row after pasting (editing) multiple rows

I'm using a Google Spreadsheet and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
2
votes
1answer
702 views

Google Apps Script - exceeded maximum execution time

I'm currently developing a new spreadsheet for my company to make one of the tasks we do on a weekly basis more easier - the way it works is data is imported into this spreadsheet and then the scripts ...
2
votes
2answers
1k views

Calculate days between now and a future date

I need to calculate how many days are left from today to a certain date in the future in a Google Spreadsheet. How can I do that?
2
votes
2answers
91 views

Google Spreadsheet - periodically stamp sheet contents

As the title, is there a way to have a "print" of the content of a sheet periodically? i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a ...
2
votes
1answer
94 views

Counting the number of matches between an “answer key” row and a “student response” row

I have a row containing an answer key for a multiple choice exam and then below that a number of rows containing the answers from students. A very simple question: how can I count the number of ...
2
votes
1answer
63 views

How to COUNTIF cells are years in Google Spreadsheet?

I have several dates in let's say: A1:A with this syntax: dd/mm/yyyy and I would like to COUNTIF the cells that are years. I started with this formula, but that didn't work: ...
2
votes
1answer
676 views

Google Spreadsheets: Unique Values From a Matrix

I have a spreadsheet that looks like this: Column A | Column B | An unimportant value 1 | Value 1, Value 2 2 | 3 | Value 3 4 | Value 3, Value 1 | Don't ...
2
votes
1answer
42 views

Can I make modifiable part of the web address passed through in a Google Spreadsheets =ImportHtml function?

Wondering if there is a way to modify part of the web address (passed through in double quotes) in a =ImportHtml function in Google Spreadsheets? eg. www.schoolgrades.com/tom ...
2
votes
1answer
5k views

Google Spreadsheet - How to filter, SUM and display multiple values with multiple conditions added daily?

I have a spreadsheet that collects dozens of payments made daily through different means. For example, utilities bills, credit cards bills, personnel fees, expenses, etc. They are made in cash, by ...
2
votes
1answer
481 views

Change contents of cell based on date range in Google spreadsheet

I’m trying to get a cell to change its value based on a date range. Let's say I have this list: A B date1 10 date2 25 date3 50 date4 85 On date1 I will have 10 items, date2 I ...
2
votes
1answer
2k views

Creating duplicate Google spreadsheets that filter data from a master sheet and update rows on master sheet

Basically, I have a huge list of data on Google Docs spreadsheets, and a bunch of people that read it. They are not tech savvy. I am trying to create duplicate sheets on a Google spreadsheet that are ...
2
votes
1answer
155 views

Flatten (pivot) table into a three column array on a Google Spreadsheet

I have a table which looks like this: A B C D 1 red blue green white 2 blue red white yellow 3 red blue green white 4 red blue green white and would like to get a ...
2
votes
1answer
750 views

Google Spreadsheet not loading

I have a Google Spreadsheet with a lot of very important data and some scripts that where working well. At some point, the browser crash and I reload the page. After that, I can't access that (only ...
2
votes
1answer
889 views

Get YEAR() and MONTH() from a string like “September 2013” in Google spreadsheet

I have a sheet with column A listing the month of the year in human readable format e.g. "December 2013", and column B listing a calculated value of bills issued in that month (from another sheet). I ...
2
votes
2answers
1k views

How to do a Google Spreadsheet equivalent to SQL's JOIN and SUM( )?

I have this table: | A | B | |---------|-----| | grocery | $10 | | clothes | $40 | | grocery | $19 | etc. So I'd like to have a column with an aggregation of the categories like grocery ...