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

learn more… | top users | synonyms (1)

0
votes
0answers
20 views

Formula for getting format of a cell in Google Sheets [duplicate]

I'd like to be able to return formatting information about a cell with output similar to that of the CELL command. Ideally, this would be something like CELL("format", A2), and if A2 was bolded, or in ...
0
votes
0answers
35 views

Google Sheets IMPORTRANGE + QUERY won't import IMAGE

I use Sheets in my business to create product catalogs for wholesale prices. I have different sheets for different companies but the data in many of them is the same. I'd like these sheets to sync ...
0
votes
0answers
16 views

Google spreadsheet: Pasting value not function

I am writing a spreadsheet that imports values from webpages that change a lot, I want to keep note on these values over the days of a week. However I'm unsure of how to note them at certain times. ...
0
votes
2answers
39 views

Google Spreadsheet criteria if cell above is blank

I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the column above. Consider the following example: A | B | C --------------------------------- ...
0
votes
0answers
27 views

Auto sort a column and auto duplicate all sheets to one sheet

The title speaks for itself. I am looking to do two things in Google Sheets, because I am entering data from a different third-party app using Google API. First: I need Google Sheets to auto sort a ...
0
votes
0answers
15 views

Automatically creating sheets across different google spreadsheets

I have one spreadsheet that collects the Google form data that is submitted. I then created spreadsheets titled "A-D", "E-H", "I-L", and so on to create the alphabet. I would like students to use ...
0
votes
0answers
18 views

Automatically create google spreadsheets from master list

I am trying to create new sheets automatically based on a list of items. I came across your answer to a question here , but the example sheet it points to is no longer valid. I am working with this ...
0
votes
0answers
25 views

How to copy permissions across sheets?

Named ranges are duplicated when their sheet is duplicated. However, protected ranges are not. I have 40 protected ranges on a sheet that I need to replicate 6 times, so I'm not really looking ...
0
votes
1answer
24 views

Linking a URL to text using google script in spreadsheet

I have a URL ready to be followed. I am sending an email using Google script, and in this email I need this link to be there... but I do not want it to be: ...
0
votes
1answer
8 views

Have indirect update row when pasted on new rows

According to this answer, I am fetching data from another sheet over rows: http://webapps.stackexchange.com/a/24478/29203 The problem for me is as I am fetching over rows, the supplied answer does ...
0
votes
0answers
36 views

Formula query to perform dynamic sum

I am creating a spreadsheet which looks up values from a second sheet. I need to SUM various sections in the sheet but these are variable - the row that needs SUMing can change at every fresh import ...
0
votes
0answers
12 views

Google Spreadsheets “Share with others” notification popup

How can I disable or stop from appearing the “Share with user” popup? This notification appears each time I start my script and only on one user, which already confirmed the sharing invitation.
0
votes
0answers
13 views

Freezing formula values in Google Spreadsheets

I have a spreadsheet that will receive new values pulled from an email via Apps Script once a day. I'd like to be able to "log" certain values over a specific length by loading them into a new cell ...
0
votes
0answers
12 views

Table of Contents with URL for each sheet

I have a spreadsheet with 600+ sheets. I have a lovely script that will alpha sort the sheets for me (more are being added each week), but what I really need is a Table of Contents tab that lists that ...
0
votes
0answers
14 views

Query in google spreadsheets

I have the following problem: In Sheet2 I have some dates and names like: A B C D E F G .... March April May .... 1 2 3 4 5 .... 1 2 3 4 ...
0
votes
0answers
19 views

How do I transpose data in a Google Spreadsheet and keep the formatting?

If we select a empty line and we type: =TRANSPOSE(A1:C27) We will invert everything from A1 to C27. However, formatting will be lost. Is there anyway to keep the format too?
0
votes
0answers
12 views

Google Spreadsheet forcing time format to non English language

I have created a sheet that has time point displayed for each record. Example: 2:30 PM, 4:30 AM As my sheet is going to be used in India, I changed location in the setting and right after that, it ...
0
votes
0answers
8 views

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
0
votes
1answer
25 views

Google spreadsheet thinks Chrome is Firefox

I am an Ubuntu user with Google Chrome 39.0 and whenever I enter a Google Spreadsheet-document (with Chrome), I get a warning header saying that "This version of Firefox is no longer supported, please ...
0
votes
1answer
86 views

Click cell in Google Spreadsheet to open data in popup

Is it possible to have a cell that just says "click me" or whatever, which opens a popup so you can see the full data? I want to keep all my data contained in one row per item, but one cell per item ...
0
votes
1answer
55 views

Can Google Forms & Sheets serve as a kind of DB?

Pardon the naive way I am expressing this question. I'm a teacher trying to create a database of grades. I'm trying to figure out if Google Sheets and Google Forms is sufficient for my task or if I ...
0
votes
0answers
23 views

Moving data between columns in google sheets

I want to manage my tasks in Google Sheets. Right now I list all my tasks in column C (as shown below) Is there a way to 'indicate' that a field in column C has been done (like I have in Column A) - ...
0
votes
0answers
19 views

“Service using too much computer time for one day” Can I see computer time per sheet?

With my Google Spreadsheets I keep getting "Service using too much computer time for one day" messages. I have already tried removing some older sheets and reducing calls to custom functions and ...
0
votes
0answers
22 views

Manage time series in Google Sheets

I'm working a data sheet that models some goods cost and benefit across a number of years. I have some values in a grid where row is a data point name and column is the year, relative to buy time. | ...
0
votes
1answer
49 views

Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically

I made a spreadsheet for tracking weight, where each row is one day, and one column is weight. Although I've had Google Spreadsheet create a row for every date in the year, I only measure my weight a ...
0
votes
0answers
30 views

Google Spreadsheet COUNTIF in ARRAYFORMULA

I currently have this formula in column P, starting in P2 and continuing down the page, =IF(A2="", "", COUNTIF(E$2:E2,"Rejected (overdue application)")) =IF(A3="", "", COUNTIF(E$3:E3,"Rejected ...
0
votes
1answer
49 views

Find the nth occurrence of variable, look at adjacent cell and organise in an array

I have a Google spreadsheet with two arrays: The first is a list of ~100 names (in a single column) with the adjacent column being the variable (A,B,C,D,E,F,G,H,I or J). The purpose is to group people ...
0
votes
0answers
32 views

Trying to convert “=importhtml” to UrlFetchApp.js

I'm trying to replace my cell which is =importhtml into a .js for Google App Script. The current function in Google Sheets now is =importhtml("http://www.gurufocus.com/financials/"&'Raw ...
0
votes
0answers
119 views

How can I stop Google Spreadsheet Now() function from auto updating?

I'm using the now() function as a shortcut to insert the current timestamp. However, the value of the time in the cell changes whenever the spreadsheet is modified. How can I stop the value in the ...
0
votes
0answers
27 views

Fill-down in Google Spreadsheets

I'm looking for something in Google Spreadsheets that provides fill-down functionality. Equivalent to Ctrl-D in Excel. I am selecting a range of cells for the fill using named ranges. The range is ...
0
votes
0answers
11 views

How do I improve this encodeURL Google Sheet custom function so that it no longer invokes too many times per second?

Here is my Google Sheet function encodeURL: function encodeURL ( r ) { if ( r.constructor == Array ) { var out = r.slice(); for ( i=0; i< r.length; i++){ for ( j=0; j< ...
0
votes
1answer
47 views

How to get the count of the current sheet?

I have a spreadsheet that I have spread out over many sheets. However, I could automate the filling out of some simple data by doing some simple calculations. I could program something simple like ...
0
votes
1answer
155 views

Relative copy conditional formatting that references other worksheet

I have a group of worksheets, one of which has 'default' values while the others should only have values if they differs from the default worksheet. To facilitate this, I want to use conditional ...
0
votes
0answers
70 views

How do I sum cells according to cell or font color?

I would like to sum cells based on either the color of the cell or the color of the text contained therein. I guess there was a way to do this before the update, but it doesn't seem to work anymore. ...
0
votes
1answer
58 views

How to add some text value in cell

I am newbie in Google Spreadsheets, but I would like to know how I can select a column with values and add in every selected cell some text, i.e <KB> . Is possible to perform via Regex ...
0
votes
0answers
46 views

How to make my Excel formula work when transferring it to Google Spreadsheets

I am trying to convert an Excel program that tracks repairs inputed by staff and updates a master file. I had the formula working and once I had transferred it to Google Spreadsheets it stopped ...
0
votes
0answers
21 views

Where is the official comprehensive reference page Google spreadsheet URLs

Google Spreadsheets URL Syntax and Display Options? was a question that was answered by referring to an old page: http://code.google.com/apis/spreadsheets/data/2.0/reference.html#Parameters ...
0
votes
0answers
33 views

Listing live stock prices with 15 minute intervals in Google sheets

I use google Sheets to keep an eye on stocks. Their live data is all I need. I would like to have a sheet that adds a new row with the stock price and time every 15 minutes. Is this possible with the ...
0
votes
1answer
64 views

Counting occurrences in Google Spreadsheet

I've been brought on last minute to sort out tent allocation for a festival of about 1500 pax. Their ticket sales are a spreadsheet on Google Drive. I have never done this kind of thing before (I'm ...
0
votes
0answers
254 views

Complex Index and Match with three criteria

I need to create a formula that will match three criteria in a range on another sheet, and where they match, return the value in an adjacent cell. The problem I have is that one of the criteria is a ...
0
votes
1answer
35 views

Auto Insert Address on adjacent cell

I am trying to create a spreadsheet which enters address automatically on adjacent cell when I type in the company name. The script will be as I type in company name in cell A1, it will search for ...
0
votes
1answer
3k views

Error: Circular dependency detected

I am very beginner to google scripting. Here I need to count the number of times the word "FREE" occurred in my sheet. But my function Returns me an error "Error: Circular dependency detected" Please ...
0
votes
1answer
585 views

Copy cell from cell to another sheet if row contains x

I'm new to sheets, I have a sheet with 10 pages. I need to auto fill sheet Report if sheet David contains "1" in column "i". I need to copy cells C14 - C34, J14 - J34 and L14 - L34 only if there is ...
0
votes
0answers
52 views

Equivalent of Google's ImportXML in Excel Online

I wonder what is the equivalent of Google's ImportXML in Excel Online? I basically need my workbook to get an external XML data, and refresh it every X minutes.
0
votes
0answers
148 views

How to get Google Spreadsheets to auto-update a reference to another sheet

Referencing: How can I get Google Sheets to auto-update a reference to another sheet? I am trying to do the EXACT same thing for the EXACT same reason. I assume this is a VERY clever work around but ...
0
votes
0answers
17 views

OR function doesn't work inside FILTER [duplicate]

When I use FILTER(A2:A; OR(C2:C >0; D2:D >0)) I get different range intervals error, but when I remove the OR it doesn't return an error. So why OR function can't be used with FILTER function?
0
votes
0answers
244 views

Countdown timer list

Can someone check the javascript code and see what can be done. I am struggling to add B2 time to the start time I think i need to convert B2 time to milliseconds and them sum with the start time to ...
0
votes
0answers
18 views

Spreadsheet not sorting properlty

When I attempt to Sort a spreadsheet by the information in a column I am greeted with the result: "This operation is not permitted because it would alter the structure of this table. More ...
0
votes
0answers
8 views

Keep track of printing in Google Sheets

In Google Sheets is there a function that will record and update a field every time a file is printed? Couldn't find anything in the docs. I'm trying to automate a version number for printed hard ...
0
votes
1answer
43 views

Search for multiple variables in multiples rows at the same time in Google Sheets/Drive

I'm using Google Sheets (only option, sorry, know this should be a database). Sheet 1: List of 200 employee names, and up to 10 location codes they are frequently assigned to. Sheet 2: List of 50 ...