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

learn more… | top users | synonyms (2)

2
votes
1answer
433 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
990 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
592 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
619 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
814 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
461 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
1answer
25 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
1answer
33 views

How to delete a group of cells and shift the rest up?

In MS Excel, it is possible to select any rectangular range of cells and delete it in such a way that the cells below the deleted range move up to fill up its place. This feature is helpful, e.g., ...
2
votes
0answers
25 views

Google sheets query returns “loading…”

I've put together a web application that relies on a series of Google components. Google Forms collects data from users Google sheets saves the data (automatically) Additional "calculated" columns ...
2
votes
0answers
10 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
49 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
27 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
27 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
43 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 ...
2
votes
0answers
11 views

Google Sheets: how to custom number format based on value? [duplicate]

In Google Sheets, I want to format 1230000 as "1.23 M" and 1230 as "1.23 K". However, it seems I can only format either in terms of M, or K, not both. It's possible to set formatting conditions in ...
2
votes
1answer
29 views

How to split then combine data to rows

I have a Google Spreadsheet that receives data from a Quickbooks invoice entry. The data from item description has the quantity of each item separated by commas, then the items which are also ...
2
votes
1answer
57 views

Trigger Script in Spreadsheet in Similar Fashion to a Link

I currently have a button on my spreadsheet (a text box image that triggers the script). Unfortunately this button doesn't work when using a tablet. Is there a way of triggering a script to run via a ...
2
votes
1answer
30 views

Google Sheets Problem with Chart Axis

I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For ...
2
votes
0answers
33 views

I created a button in a panel (dialogue window), when I push the button I'd like to appear a new panel (dialogue) window

I created a button in Google Spreadsheet. When I push the button a custom window appears. In that window I have two buttons, one to close and one to see a new window. Everything goes well except the ...
2
votes
1answer
24 views

Adding an overtime column to a Google Sheets template that includes the overtime rate in the total

I would like to use this template to log bi-weekly hours. It is almost perfect except that there is no column for overtime hours. How would I add an overtime hours logging column that would add the ...
2
votes
0answers
82 views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields ...
2
votes
1answer
52 views

Reference an entire sheet in Google Sheets [duplicate]

Is there a way to reference an entire spreadsheet with a cell reference in Google Sheets? Say I wanted to find out how many cells in Sheet1 were non empty. In sheet two I'd want to do something like ...
2
votes
3answers
443 views

Add a time picker to Google Docs Spreadsheets?

Is there an option to add a time picker on Google Docs Spreadsheets? I don't need timezones or anything complicated. Just a string on the HH:MM format, that matches the custom format available. I ...
2
votes
1answer
71 views

Calling IMPORTRANGE inside of REGEXMATCH function?

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function. I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...
2
votes
0answers
120 views

How do I create a map from Google Sheet data that's in another sheet?

I'm trying to create a Google My Map based on addresses in a Google Sheet "file". This seems to work OK following the standard instructions, except that I can't seem to extract data on anything except ...
2
votes
0answers
164 views

Batch Hiding Function in Google Script

I wrote a function that iterates through every non-blank row in the sheet, checks the value of a certain cell, and then if that cell matches my criteria its row number is added to an array. I then ...
2
votes
0answers
386 views

Case insensitive character string filter for multiple individual columns (dynamic input for each)

I'm looking for an efficient way to filter a data set by multiple individual, case insensitive character strings for multiple columns in a Google docs spreadsheet. I can already achieve this by ...
2
votes
0answers
62 views

Google Sheets Cells don't calculate when printed or viewing as PDF

Workbook: Very large workbook with multiple tabs of data and multiple tabs of reports using sumproduct, query and filter formulas. Payroll tab is a reflection of our master database so i'm not dead ...
2
votes
0answers
104 views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
2
votes
0answers
64 views

Can't unmerge cells

I have a lot of data in a Google spreadsheet that depends on charts I spent ages trying to make look pretty. There is a stupid block of merged cells that won't unmerge, and when I try to ...
2
votes
0answers
116 views

How to make script slow down in GoogleSheets Script Editor?

I have a script thats attached below, and the problem I'm facing is that after it has keyed in "ticker" to Raw Data in b1, my entire sheet is never done loading and thus when its time to check if it's ...
2
votes
1answer
515 views

Changing cell color in a range

i have 4 columns of values in each cell, the cells are different colors : Cell A1 = 12 (color - Green) Cell B1 = 10 (color - Pink) Cell C1 = 11 (color - Blue) Cell D1 = 13 (color - Red) Cell ...
2
votes
0answers
48 views

Change logs for Google Spreadsheets

We've got a large shared spreadsheet which is a chart showing user permissions. Its writable by several people. Although Google Drive allows you to roll back the changes simply its interface isnt ...
2
votes
1answer
87 views

Is there another way to click on the hyperlink in a Google Spreadsheet?

I am aware of the process to click a link on the spreadsheet. However, is there a way where the user of the sheet can directly click on the link? I am trying to prepare a decision tree where, once a ...
2
votes
1answer
427 views

Google form to spreadsheet, create new column

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C ...
2
votes
0answers
674 views

Apps Script Webapp accessing Google Spreadsheet gets #VALUE! on every cell

I have a Google Spreadsheet with a couple of sheets that get data from other spreadsheets via ImportRange function and then calculate numeric values based on that data. Then, I assembled a code ...
2
votes
0answers
640 views

Set a Category Filter in a Google Spreadsheet Line Graph

I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
2
votes
1answer
334 views

How to do a date formula in Google Spreadsheets

I have to do a query that increments automatically the date year by year. For example I use this formula: =INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
2
votes
0answers
1k views

Delay in updating referenced cells when using importrange in Google Sheets

I'm using the importrange() function in Google Sheets to reference data from 'spreadsheet1' and display in it 'spreadsheet2'. This works fine, but if I edit 'spreadsheet1' and then go to ...