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

learn more… | top users | synonyms (2)

1
vote
0answers
52 views

Google Spreadsheets SUMPRODUCT/COUNTIF in Arrayformula

Actors\Genre 1 2 3 4 5 6 7 A B C D I need to get the counts of the movies by genres acted by the actors in the column and the movie data is in another spreadsheet, "data". I tried the formula ...
1
vote
0answers
78 views

For every occurence of x insert a new row beneath it

I'm using XPath in Google Spreadsheets. In some of my cells I receive fetched results, in others I get #REF!. The explanation given is Array result was not expanded because it would overwrite ...
1
vote
1answer
33 views

Autosum entire column

On Google Sheets, I enter my sales for the month in Column F. How can I get column F to Auto Sum so that the total always appears below the bottom entry?
1
vote
0answers
48 views

Google Spreadsheet adding new lines in between

I've encountered an issue with Google spreadsheet. When I'm trying to add some text, I'm noticing a new line being added in between. Is anyone else having the similar issue?
1
vote
0answers
22 views

Representing hierarchical data in Google spreadhsheet

Background Smartsheet.com allows hierarchical representation of data in a single sheet {without having to use adjacency lists } smartsheet hierarchical data example Question Do google ...
1
vote
0answers
18 views

In Google Sheets, how do I find elements common to two ranges? [duplicate]

Range 1 cat dog rat bat snake Range 2 cougar butterfly rat bat lizard aardvark kangaroo What formula or script would I use to get Range 3 rat bat Order is not important.
1
vote
0answers
9 views

freeze column according to column heading

I am working on attendance in Google spreadsheet, I want to protect the date column which is past date and future date, I just want to give edit right only for today date.
1
vote
0answers
87 views

How can I make Google Spreadsheet recognize dd/mm/yyyy format as a date?

I have a table copied over from other applications to a google spreadsheet. Before processing, I noticed google spreadsheet doesn't recognize 'dd/mm/yyyy' (e.g. 15/01/2015) as a date, instead it treat ...
1
vote
0answers
30 views

Retrieve row data based on indirect Max function value

This spreadsheet tracks live song ratings for a popular band. Users input their score in their own column and those scores are averaged into a community score (Column E). Those song averages are ...
1
vote
0answers
25 views

How can I check emails against a Google sheet containing a list of email addresses?

I am conducting a research study and receive many emails (via Gmail) from potential participants. I do an eligibility screen with participants over the phone, and if they are not eligible, I add their ...
1
vote
0answers
187 views

Cell-dependent cell ranges in data validation in Google Sheets

Regarding Google Sheets -- is there any way to have cell-ranges in data validation depend on the cell itself. For instance, I want G7 to accept input only from E7 and F7. Similarly, I want G8 to ...
1
vote
0answers
70 views

Filter from multiple sheets into graph using Google Spreadsheets

Context I've got a big travel expenses spreadsheet. In it, I have daily entries for different expenses labelled with things like Date Currency Ammount Exchange Rate Amount in £ (my native ...
1
vote
0answers
31 views

Jagged array from Google Spreadsheet range

The range in my Google Spreadsheet looks like this: | A | B | C | D | E | F | ...
1
vote
1answer
23 views

Change certain cells back to default value every Monday morning in Google Sheets

I have a Google spreadsheet that ~30 members can edit (one row for each member). I need to create a column showing "yes" as default in each row until the member manually changes it to "no" if he/she ...
1
vote
1answer
73 views

How to display Image from URL in Google Sheets? (and apply it to multiple rows)

So I created a list of members in Google Sheets, each member having a profile image, name, location, etc. I exported this list from import.io, a data extraction tool. The only problem is that when I ...
1
vote
0answers
218 views

Google sheets grouping function in excel equivalent or workaround?

I know you can't do it in Google sheets. I think the grouping function in Excel is one of the most useful things out there with the ability to expand or collapse rows and columns by grouping them. ...
1
vote
2answers
114 views

How to sort cells with text and numbers correctly

This is my example list: example file As you can see I am sorting all unique elements in row B. But the "Sprint 9" gets sorted as the highest value, not the lowest. I really have no clue how I can ...
1
vote
1answer
74 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 ...
1
vote
0answers
38 views

function to verify all cells in active row

I have a function which is triggered onEdit to enter an ID in new table entries: function IdGenerator(e) { // Get the active sheet var sheet = SpreadsheetApp.getActiveSheet(); // Get the ...
1
vote
0answers
69 views

Help me check if this URL is ok to query with Google Chart

For the last couple of hours been trying to get this work. I setup a demo sheet with just two colums: Name Value A 22 B 33 C 44 D 12 And want to plot it. I put this URL into ...
1
vote
1answer
378 views

Auto increment ID in Google Forms

I am designing a Google Form for managing a congress registration process. I need to have a unique ID number for each registration and I found an answear here: Can I add an autoincrement field to a ...
1
vote
0answers
12 views

Detect column D changes with Google Apps Scripts

I would like to detect if the column D rows in my spreadsheet are becoming a date (at the beginning those column rows are empty), so if D1, D2, D3 become a date their text or colors should blink. Now ...
1
vote
0answers
25 views

Is there a way to stop Google sheets from telling me to use Ctrl C?

I know the keyboard shortcuts for cut, copy and paste, and I use them frequently. But there are times when using the mouse is much more convenient. Especially if I want to copy a whole row, I prefer ...
1
vote
1answer
18 views

Subclauses in formulas?

Quite often I end up including the same calculation in a formula twice, like this: =if(iserror(vlookup("lookup",SheetX!A2:X350,5,false)),"",vlookup("lookup",SheetX!A2:X350,5,false)) I'd like to ...
1
vote
2answers
149 views

How do I get the data in a cell of the last column of a row?

I'm using Google Sheets. Every week I add a column with new data, and I need the data from the latest column copied into another sheet. The formula needs to pull the cell of the last column in the ...
1
vote
0answers
41 views

How can one serve a single google spreadsheet cell content to a web page?

I can embed a Google Docs/Spreadsheet's whole tab/table on a web page. Is there a simple way to publish the (unformated) content of a single cell?
1
vote
0answers
59 views

If condition won't work Google Spreadsheets [duplicate]

I have this formula and it doesn't work: =IF(A1="oui","1",if(A1="non","0","")) I asked a couple of friends to test it, and oddly, it works fine with them! What did I do wrong? And how do I fix it?
1
vote
0answers
30 views

Why is there sometimes no “Move to trash”/“Move to bin”

I'm trying to clean up some old Google Sheets, but some of them don't have a "move to bin" menu option: Other spreadsheets do have it: What's the difference? How can I delete spreadsheets that ...
1
vote
0answers
49 views

Dynamically creating sums from lookups

I was trying to do something similar to this post: Google Sheets advanced lookup + sum But I just can't figure out how to amend it for my purpose. I'm basically building a diet plan, where I have ...
1
vote
0answers
683 views

How to save temporary variables in Google Spreadsheet formula?

I'm trying to create a formula in Google Spreadsheet which looks like this: if (x < 0, x + 1, x) It means if x is smaller than 0, return x + 1, else return x. However, x itself is an ...
1
vote
0answers
120 views

onEdit Script to auto run Filter on a tab

I'm trying to find a script that will run in a particular way, see below: it runs on a specific tab in a spreadsheet needs to either re-run a filter that i have in place on the tab OR can filter out ...
1
vote
1answer
124 views

Pre-fill field with formula — incremental counter — in Google form [duplicate]

I have a Google Docs form that I use to track my customers complaints. Is it possible to have a "counter" field pre-fill with an incremental number? I want my customers to have a complaints number ...
1
vote
0answers
93 views

How to directly view a Google Visualization API Query URL as a human-readable table or web page?

What is the correct syntax for the URL (see also a related question about documentation) to view a Google Visualization API Query result as a web page containing the tabulated results of the query? ...
1
vote
0answers
114 views

Disable Drag & Drop Google Sheets

DEFINING DRAG & DROP: In google sheets if you have a cell or cells currently selected you can perform an operation on them. One such option is to move your cursor to the edge of the selection ...
1
vote
0answers
12 views

Pull data from a cell in one Google Sheet to another cell in a separate Google Sheet [duplicate]

I have a Google Spreadsheet with quite a few sheets in it. I am trying to pull information from that sheet and put that info into another sheet in a different Google Spreadsheet. I have googled this ...
1
vote
0answers
109 views

Auto import CSV into existing Google Sheet

I understand how to upload and convert CSV files to Google Sheets -- but how can I set up an automatic upload of all new data from a CSV file into an existing sheet? I have a CSV file that lives on ...
1
vote
0answers
27 views

Hyperlink to a cell in a Google Spreadsheet

I want a user to be able to click a link that sends them to the specific cell in a specific spreadsheet. The spreadsheet must be in edit mode aswell.
1
vote
1answer
292 views

Google spreadsheet: check if cell itself is empty

Is it possible to have a formula somehow on cell A1 that checks as a conditional if A1 is empty? Obviously, the default way I'm getting a circular dependency error. However, I figure some formula ...
1
vote
0answers
114 views

Google sheets equivalent of self-referencing in Excel

This is, in my opinion, one big advantage Excel has over Google sheets is the self-referencing formulas. What I mean by that is: say in cell A1, I'm changing the value in there a,b,c. And according ...
1
vote
0answers
192 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
1
vote
1answer
372 views

How can I sum a row in Google Spreadsheet so that the formula isn't overwritten when Google Forms adds a new row?

I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything ...
1
vote
1answer
406 views

Start new line automatically when otherwise content would overflow cell [duplicate]

I don't know when Google changed the version of Spreadsheets. Right now when the cell's text is longer than the cell width the display of this line is no longer what it used to be. I want the display ...
1
vote
1answer
23 views

How to get formulas to do the calculations

I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas ...
1
vote
0answers
391 views

Retrieve data from another sheet based on key value without empty rows

This seems pretty straight forward, and I've seen some answers that come close, but I'm having trouble nailing down one specific requirement. ...
1
vote
0answers
128 views

Trello API: How to remove a member from an organization using Google Apps Script (GAS)

In a Google Spreadsheet, I have a list of Trello usernames that I want to remove from my Trello organization. How can I use the Trello API to remove all these members from my organization? I found ...
1
vote
0answers
65 views

Send email from Google Spreadsheet to adress in column

From an existing Google Spreadsheet; every time a value is added in column M(x), I would like to send an email with a specified text to the address listed in column F(x) from the same row x. Which ...
1
vote
0answers
296 views

Yet Another Mail Merge - sending to multiple recipients

I'm required to send a parametrized mail message to multiple recipients, based on values in a Google spreadsheet. I've followed the instructions in this guide on how to use Yet Another Mail Merge. ...
1
vote
0answers
608 views

Google spreadsheet disappearing text

Whenever I enter text into a box and press enter the text disappears. I can only view the text by clicking on the box it's in. What am i doing wrong? Windows 8, Firefox 29. It only occurs in firefox. ...
1
vote
0answers
174 views

Can I make a Google spreadsheet deploy as a web application?

Well, this is what I'm planning to do: my spreadsheet looks almost done to me (a few changes here and there of course, but that'll continue forever). I want to deploy it as a web-app and then who ...
1
vote
0answers
120 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 ...