A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

3
votes
2answers
48 views

How can I sort in Google Sheets by cells containing section (or version) numbers?

I'm indexing a document with sections and sub-sections. I want to have one column representing the section-number and be able to sort by this column. However when the sub-section gets higher than 10, ...
3
votes
2answers
73 views

Coloring cells according to the value to which its content is closest

I am trying to make a guide for my dragons on a game I play but I'm not quite sure how to code what I am trying to do. Link ex. if has values "Guardian"(C2:C100) and "Dragoness"(I2:I100) in its row ...
3
votes
2answers
287 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
2
votes
2answers
23 views

Update the reference in Indirect() when new columns are added

I have a a very large spreadsheet that pulls data from another logsheet through an Indirect depending on user input on cell A1. =INDIRECT($A$1&" Data!$AG$3") I'm trying to add some new columns ...
1
vote
2answers
35 views

JavaScript To Dynamically & Daily Select The Next Worksheet In An Open Google Sheets File

At work using Chrome, I have a Google Sheets file saved on my Google Drive folder that's shared with me with edit privileges that I keep open on my MacBook Pro. After I've originally opened the file ...
1
vote
1answer
10 views

Google sheets: My timesheet is a pre-filled list of dates for the whole year How can I get quickly to today's date?

Or at least, to the last entry I made? remember - i may enter my hours on last friday, but the sheet already has next monday's date pre-filled, so ctrl/end doesn't work. the year goes to March 2017....
1
vote
1answer
14 views

Importrange All Sheets

Is there anyway to call an IMPORTRANGE() and have it include all sheets? Here is my current function that combines the current data with the first archive, I'd like to set it up as a failsafe for the ...
1
vote
1answer
14 views

How can I change the value of one cell in Google sheets based on what is entered into another?

Using Google Sheets, I have a dropdown list of different actions, and each action has a different score associated with it. Eg. Action a = 5 points, Action b = 7 points etc How I can make Google ...
1
vote
1answer
15 views

Querying multiple ranges from form responses to new sheet

Recently, someone on this forum put together a formula for me. It works on a sheet pulling responses from a google form. I'm trying to model a new one after that but I'm having trouble. The working ...
1
vote
1answer
15 views

Filter numbers in one column based on whether they are higher than in another column

How to filter numerical data in column B based on whether or not the number is higher than the number in column A?
1
vote
1answer
20 views

If a string is contained in a row return return the value of the first cell of the row

I've this Google Spreadsheet: https://docs.google.com/spreadsheets/d/1-QV49oKCf58HgLBgC8gJ3gc6IXJZAo2xvh6vPTjY05o/edit?usp=sharing check the row in Sheet1 where the domain in Sheet2 is contained ...
1
vote
1answer
32 views

How do I copy data if cell contains text?

Basically, I have a book which gets data anytime someone fills a form. There are five groups I need the data divided into. If a cell contains one of the five answers all the answers by user need to ...
1
vote
1answer
28 views

Combining columns horizontally with an arrayformula

I need to join columns with a formula (not a script) in Google Sheets in a different way than others I've found--here is my original data, supposing that the Avengers train by playing racquetball: ...
1
vote
1answer
30 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
1
vote
1answer
36 views

Script to delete a dynamic range of rows

I'm looking for a script that allows me to delete a dynamic range of rows. Basically I have a script that adds rows to the bottom of a list but I want another script that will delete all rows in the ...
1
vote
1answer
83 views

How to embed Google Sheet into Google Document and keep the Google Sheet format

How do I embed a Google Sheet into a google document and keep the Google Sheet format in the document? I have got this far with the script but it's not working function updateData() { var ssUrl = '...
1
vote
1answer
58 views

How to auto generate the date a URL was last updated?

I'm trying to find out if it's possible to fetch the date a URL was last updated. So column A I'd have the URL and column B the data would auto generate. I'm guessing this would be done using some ...
1
vote
1answer
105 views

Google Sheets - Keep multiple sheets synced (both ways)

I need to have multiple Google Sheets be synced both ways. For example: I have a "master" sheet that has all of my information. And then I have multiple "filtered" sheets. Each filtered sheet only ...
1
vote
1answer
48 views

How can I automatically set “sheets last updated” in a cell on Google Docs Spreadsheets?

Simple task!.. output a date and time every time something in the sheet is edited! function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets("Data"); var ...
1
vote
1answer
37 views

How to get most frequent terms from a set of lists?

I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, Batman,...
1
vote
1answer
27 views

Update latest spend on Google Sheets based on Date dimension

I have a spreadsheet report -- used to monitor our marketing campaign reports. So my goal here is to be able to update a cell showing the our current spending as of yesterday. How can I go about ...
1
vote
1answer
776 views

Reference a Google Spreadsheet Row containing specific Text within Google App Script for spreadsheets

I am having trouble finding a function that can reference a row (the number of that row) containing specific text as criteria. I thought that VLookUp would work, but it's not really. Ideally it's ...
1
vote
1answer
204 views

How can I personalize HTML emails using Mail Merge and Google Spreadsheets?

I'm attempting to personalize an email that uses HTML coding. Basically, I've made an HTML template that I want to have say the name of a person within the HTML code as well as the subject line of the ...
1
vote
1answer
233 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
15 views

Highlight two numbers if they are different

So I have a sheet that requires me to confirm if two numbers in different columns are the same and would highlight them if they are different. The two numbers are always One row and column apart, so ...
0
votes
1answer
9 views

Embed Google Doc within a Google Spreadsheet

Is it possible to have a big spreadsheet with many sheets and have one sheet that has an embedded Google Doc? This would allow me to use the Google Spreadsheet as a dashboard and individually ...
0
votes
1answer
9 views

Conditional Formatting Referencing another Cell (and using addition)

I am tracking high school credit acquisition. Each trimester a student must earn 2 credits to remain on track. If Cell A1 is "trimester 1 total credits", and cell B1 is "trimester 2 total credits", I ...
0
votes
1answer
21 views

Compare date value to current date in Google Sheets

How can I compare the date in a row to a current date, so that if it's greater than today the next steps in my process need to be executed?
0
votes
1answer
11 views

Populate a cell with a different cell when selecting from a drop down

I have a drop down with the following: Bin Run, Single Clean, Single Clean Bagged. I want to populate Cell G41 With contents from cell I18 when my dropdown says "Bin Run". I have this formula as ...
0
votes
1answer
26 views

How to allow users to enter some data in Google Sheet without actually modifying the content?

I'd like to make a sort of calculator based on a grid, where the user checks different lines/columns and it will calculate some stuff based on what's checked. Perhaps I could do something in HTML/...
0
votes
1answer
42 views

Copy a row and add to the bottom of a list

I'm looking for script that will allow me to copy a specific row and paste it to the bottom of a list. The bottom of the list will not be the last row on the sheet. Using VBA I would have used an ...
0
votes
1answer
38 views

Sort column from another sheet alphabetically

I have a sheet that has a column of names. I want to have another sheet that copies all of the entries from this column in sheet 1 and alphabetizes them automatically as I add new entries into sheet 1....
0
votes
1answer
193 views

Conditional deleting in Google Spreadsheets

I'm using two sheets, one with the main values and reference datas. The second sheet is for price calculation. I use =Filter to get the values from sheet one where Sheet1!E2:E <> 1. How can I ...
0
votes
1answer
145 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?
-1
votes
1answer
49 views

Getting e-mail adresses using a filter in Google Sheets /w scripts

I am trying to extra email replies from gmail. I already found some code that is supposed to work. My question is: how can one expand it to support a filter as a variable? (in this case so a filter ...
-1
votes
1answer
188 views

How to calculate with cells that contain two values separated by linebreak?

I've got a Google spreadsheet that looks like this: Start time | End Time | Time difference -------------+---------------+----------------- 11:30:00 | 12:45:00 | 1,25 -------...
-1
votes
1answer
355 views

Need Help With a Script to Automatically Insert Rows in a Sheet Based on Other Rows/ Data Inserted in Another Sheet

I have a sheet titled 'Raw_Data' that I insert data into every day by inserting new rows above the data from the last day. I have another sheet titled 'Overall_Formulas' that populates formulas based ...
-1
votes
1answer
95 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
479 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
992 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
15 views

ParseError on spreadsheets

I am receiving a "Parse Error" on this function: =loadBlueprints("corp",4324234,"7okqZ1gOyG43243243242342qb2wkyd21C",90926985) this turns out to be a parse Error though i do not see where it may be....
-3
votes
1answer
30 views

Use regexmatch to determine if one cell's content contains another's

I want use a cell in regexmatch as regular_expression parameter. My goal is to draw green background for A1 if B1 contains A1 inside of it. How to do this with regexmatch?
-3
votes
1answer
358 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 ...