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

learn more… | top users | synonyms (2)

1
vote
1answer
363 views

How can I automate a series of actions, after receiving an email in GMail?

Here's what I want to do... When an email with a known subject, or from a known source, is viewed I want a button that will: Add data from the email (could just regex parse) to a new row in the ...
1
vote
1answer
2k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
1
vote
2answers
576 views

Google spreadsheet flextime

Being a (productive) geek, I want to keep track of the trend of my flextime. I keep a personal document of my hours worked in a Google Spreadsheet, having one column for hours worked every day. By ...
1
vote
1answer
5k views

Applying two filter functions in Google Spreadsheets

I am trying to apply two filter functions in Google Spreadsheets: Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) ...
1
vote
1answer
384 views

Google Docs Spreadsheet sections

I'm using Google Spreadsheets. I want to be able to have several different sections all on one spreadsheet: an income section with totals there an expense section with totals in it etc. How do ...
1
vote
1answer
368 views

Google Spreadsheets Data Management

I am looking for a way to manage the input of some data in Google Spreadsheets. Before I roll up my sleeves and write a new UI using the Google API I thought I would see if there was anything out ...
1
vote
1answer
88 views

How to dash a whole row if a cell is OK?

I have a cell that can be OK, ERROR or WARNING. When it is changed to OK I want to modify the whole row in some way. I was thinking about to dash all cells. Is it possible? Or is there something I ...
1
vote
1answer
757 views

How can I charts based on day and month using dates in google spreadsheet?

I have a Google spreadsheet that has values like 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
1
vote
1answer
6 views

How do I change the year in Google spreadsheets

I'm copying and pasting things over from an old spreadsheet and the original dates where marked like '25/4' so dd/mm but I never included the year, well the problem is these where dated in 2014 but ...
1
vote
0answers
23 views

Dropdown menus drop-off

I have a Google Sheet application (url below) that uses dropdown menus to allow selection of data to display (one line selected from 5000). It works quite well BUT once the file is shared, for some ...
1
vote
0answers
7 views

Drag to change referenced cell in Google Sheets as Libre Office Calc does?

In LOC when double clicking cell A1 that has the formula '=B1*C1', both B1 and C1 have a coloured border that is drag-able. Dragging B1's border to D1 now makes the formula in A1 '=D1*C1'. In Sheets ...
1
vote
0answers
31 views

Counta Function Counting One Extra Filled In Line

I am creating a register for some workshops to introduce people's personal information, organized by when these workshops are taking place. I have six different spreadsheets (Monday, Tuesday, ...
1
vote
0answers
17 views

Using drop down menus in Google Spreadsheets to display additional information. In this case scheduling

Quick Overview: I am trying to create a simple easy way to look at a master schedule for a complete year. Each Event has a time, place and coordinator. Sheet 2 would be the master schedule for the ...
1
vote
0answers
9 views

How do do Conditional Formatting to compare cell contents between to Worksheet tabs [duplicate]

So, I've got two tabs in a Google Spreadsheet. I want to compare the contents and see which are different. Ideally, I'd like to use Conditional Formatting to format the cells that don't match. I.e., ...
1
vote
1answer
10 views

Formatting cells based on upcoming date in Google sheets

I am trying to format a cell to be highlighted red if the following conditions are true: the future date associated with that row (which is in a separate cell) is less than 21 days from today, and ...
1
vote
0answers
18 views

Google spreadsheet dynamically populated list

So I am working on creating a spreadsheet for the game League of Legends. Specifically equipping the various champions with items. The calculations for the basic bonus to stats are simple but many of ...
1
vote
0answers
13 views

Deleting common row in Google Sheets [duplicate]

I have a Google spreadsheet and I am trying to obtain the difference/complement of two lists where the second list is a subset of the first. Is there any function which does the below? Example: ...
1
vote
0answers
12 views

Narrow sample space down with Google Forms evaluation

I got the results from a survey I did with Google Forms. The survey results are stored in a Google Spreadsheet (150 rows). I really like the feature to get the results in diagrams automatically, but ...
1
vote
0answers
19 views

How to calculate interest rate from start and end amounts in Google Sheets? [duplicate]

What is the formula and result for working out the interest rate required for making £38106 into £73036 in 20 years? (As if you put £38106 into a bank account and left it for 20 years, never taking ...
1
vote
1answer
13 views

Link in Google Sheets to either create a new document or link to the one that was previously created

I'd like to provide a column in a spreadsheet that allows the user to create a note for the column by clicking on a link. If the note has never been created, it will create the link to a new document ...
1
vote
1answer
27 views

Relative Conditional Formatting with Google Sheets

I'm trying to use conditional formatting in the goals area. Currently the calorie goal (J10) turns green as long as I stay under it's number, and it's compared to the total calories for the day (J3). ...
1
vote
1answer
18 views

Same x-axis for multiply graphs in same plot window

I am trying to do exactly what the answer in this link explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference: I don't have simply one ...
1
vote
0answers
11 views

Google spreadsheet: How to paste rows but not overwriting existing rows? [duplicate]

Here is what I want to do: I have rows 1,2 and rows 3,4. Now I would like to copy rows 3,4 before rows 1,2. I.e., after pasting the rows, I will have six rows. Rows 1,2 is the same as the previous ...
1
vote
1answer
31 views

Get the sum of every row in a table imported with Importhtml

I've figured out how to import HTML table into Google spreadsheets, but is there a way to sum a row? I want to get a sum of Total Revenue from Nasdaq. This allowed me to pull the quarterly data from ...
1
vote
1answer
42 views

Method to filter based on dropdown list of months

I'm trying to convert an Excel spreadsheet into Google Sheets. I have the entire year on a sheet and would like to filter the list based on a selected month from a dropdown. For example, selecting ...
1
vote
0answers
36 views

Adding columns automatically to Google Sheets

I am using Zaption and Socrative as assessment tools while teaching. After I download the CSV files, I import them to Google Sheets. I figured out a way of having the results sent to a PDF after ...
1
vote
1answer
17 views

Custom highlighting style on Google Spreadsheet

I am new to Google spreadsheet and I'm wondering if there are any other ways to draw attention to a box rather than just change its colour. I want to emphasize a box drawing a circle on it. I saw ...
1
vote
0answers
17 views

Ensure results stay in redesignated column and don't migrate back to original column

Before updating my spreadsheet to fetch new information from the provided scripts, I insert a new column in between the input column (A) and the results column (B). I want my new results to be next to ...
1
vote
0answers
45 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
29 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
46 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
19 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
28 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
20 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
163 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
1answer
92 views

How to edit a particular sheet using Google Forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form. I wanted users to select a category and ...
1
vote
0answers
64 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
30 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
21 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
0answers
32 views

Equivalent of Ctrl+Apostrophe in Google Sheets

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...
1
vote
1answer
56 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
177 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
99 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
0answers
22 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. ...
1
vote
1answer
63 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
92 views

How to change default row height of a migrated Google Spreadsheet

The old Google Spreadsheet has a default row height of 17. The new Google Sheets has a default row height of 21. After a spreadsheet is auto-migrated by Google to the new Google Sheets, the original ...
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 ...