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

learn more… | top users | synonyms (2)

3
votes
2answers
2k views

Protect Formatting (Validation)

I have a very complicated tool that I developed that produces a mass amount of information. Technically, the whole sheet should be a database drive website. However, it is a spreadsheet: ...
1
vote
2answers
82 views

How to display a character when a value in the same row is the highest value in its column?

I have the following example table: A | B a | 5 b | 3 c | 1 d | 9 <=== expected result e | 0 f | 4 So it should display d as in the other column 9 is the highest value.
1
vote
2answers
160 views

Auto sort a sheet so that entries remain in their categories

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
1
vote
2answers
895 views

How to SUM() a column from one Google Spreadsheet in another spreadsheet

Has anyone been able to return the SUM() result of a column in one Google Spreadsheet to a different spreadsheet? I am trying the ImportRange(key, criteria) but I am not having any success. I am just ...
1
vote
1answer
1k views

Multiple views of master spreadsheet that allow editing of master data

I have a monster spreadsheet with lots of contacts in it. Each contact is a row, with different attributes as columns (first_name, last_name, number, etc.). There are a hundreds columns—i.e., too many ...
1
vote
1answer
74 views

Using a dynamic OFFSET & ISBLANK() function

I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above ...
1
vote
1answer
62 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
1
vote
1answer
168 views

Download list of contact information and check if Google Account

I'm looking for a way I could: retrieve a list of all my contacts and their email's and In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
1answer
88 views

Cursor position in Google Spreadsheet

In a google Spreadsheet the cursor is always behind the last letter not in front. How can I change that?
0
votes
1answer
166 views

Use sort function but filter results

I'm looking to use the =SORT function on some data, but I only want the first result with that name. Column A contains a Name, column B contains a level, and column C contains a date. I'm currently ...
-1
votes
1answer
91 views

Google Spreadsheet Paste

I need to copy and paste content from one sheet to another sheet within the same file, keeping formulas where there are formulas, and keeping data where there is just data. I tested every "paste ...
-2
votes
1answer
160 views

Google Sheets query with sum and group by

I am trying to have a query that selects certain columns, checks a date criteria, sums up total and has a group by criteria. My formula is not working. Can you guide me into what I have done wrong? ...
-2
votes
1answer
916 views

Simple row references in Google Spreadsheets and resorting data

This is my scenario Users are entering data into rows with several columns Last column is calculated on values of few previous columns (so it's row number independent). While entering new and ...
-3
votes
1answer
315 views

How do I conditionally format based on the value of cells in a column?

Unable to create a script. I would like to know if there is one that would allow me to color an entire row based on the value (a different color value) that I will find in the cells of column B. For ...