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

learn more… | top users | synonyms (2)

3
votes
2answers
63 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
272 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
45 views

How can I trigger a function when switching sheets within a spreadsheet?

How can I trigger a function when switching sheets? Let's say I'm viewing a multi-sheet spreadsheet. Now I want a function to run whenever I switch from one sheet (tab) to another. Is that possible? ...
1
vote
2answers
28 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, ...
9
votes
1answer
350 views

Google Sheets - Script to change individual text color within a cell

I have a Google spreadsheet with hundreds of employee names for a schedule. Each cell has multiple names within that cell that look like this: First Last First Last First Last First Last First Last ...
6
votes
1answer
62 views

Can I jump to next cell containing invalid data in Google Sheets?

I have a Google sheet containing lots of data, and some of it doesn't respect the data validation rules (and the little red triangle appears). Since I have a lot of data, it's quite a long process to ...
4
votes
1answer
306 views

Google Spreadsheets showing “shared with xxx” count greater than actual?

For every one of my Google Spreadsheets, the sharing settings is on "Specific people can access", and each sheet is shared with 3 people I know. Their names are listed when I click on the blue "Share" ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
3
votes
1answer
76 views

Problem: Script does not trigger on FormSubmit: Removing Duplicates in Google Sheet of Form Responses based on a column

I am trying to remove older duplicate form responses based on a column using the following code. The credit for the code goes to: ...
3
votes
1answer
34 views

Highlight/reject cells that contain any of the values from another sheet

I have a sheet/tab that contains nothing but a single column where each row is a word, let's call it wordlist. In another sheet/tab, I would like to make it so that for one of the columns, if the ...
3
votes
1answer
277 views

The default number of rows for “Add more rows” at the bottom of Google Sheets

At the bottom of Google Sheet web application, there is an 'Add' button and '1000' is the default number of rows to be added. Can I change this default number?
3
votes
1answer
424 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
2
votes
1answer
44 views

Is there a way to automatically duplicate 8191 google sheets and name then 1-8191 + copy their urls and add them to another sheet?

Background: For a genealogy project I've created a Google sheet where participants enter all details of one ancestor. (FILEXXXX) In another Google sheet (not just another tab/sheet, another FILE) ...
2
votes
1answer
47 views

How to show instead of hide repeated values in pivot table?

By standard, repeated values in pivot table are only shown once. I made an example sheet to illustrate: This becomes a problem for people who use filters over pivot tables: Notice how Donald's ...
2
votes
1answer
29 views

Selecting a single column from all rows for chart range

I want to specify a certain column from all rows (omitting the first few) to be the range for my chart. Currently I input this to specify the range: L6:L (note: this automatically changes to L6:L20 ...
2
votes
1answer
148 views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
2
votes
1answer
51 views

Filter rows by a set of numbers from another row

I have row of six digit numbers where I want to filter rows containing exact numbers set. For example: orderid 154934 154935 154936 154937 154938 154939 154940 I want to filter 154935,154937 these ...
2
votes
1answer
61 views

Sum columns based on conditions

I am working for a webhosting company and we are tracking our efforts with Google Sheets. I was trying to find a solution for the following problem: We track our efforts by clients per day, so that ...
2
votes
1answer
882 views

Problem adding Image to hyperlink in Google Sheets

I want an image to be my hyperlink in Google sheets. Here is my formula: =HYPERLINK("google.com/de", IMAGE("http://s5.favim.com/orig/69/hi-love-quote-start-Favim.com-658946.jpg")) The image shows ...
2
votes
1answer
67 views

Change logs for Google Spreadsheets

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

Copy one Google Spreadsheet to another

I am developing a Google spreadsheet that I want to make publicly accessible to a community. I've released the first version of it, and now everybody in the community has that first version's link ...
1
vote
1answer
16 views

Google Sheets formula for weekly column totals

I'm a bit of a newbie to Google Sheets formulas and such. I have a set of data entered daily with the dates converted by WEEKNUM() to display and allow me to filter by week no. I want to add the ...
1
vote
1answer
34 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
32 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
64 views

How to embed an image inside a Google Document comment?

I add comments all the time to Google Documents, however i would like to embed images inside Google Document comments (similar to how you can add images to facebook comments). Is this possible and if ...
1
vote
1answer
28 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, ...
1
vote
1answer
22 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
560 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
197 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
220 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
4 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 ...
0
votes
1answer
18 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
19 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 ...
0
votes
1answer
115 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
131 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
186 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
127 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
281 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
94 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
421 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
974 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
352 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 ...
0
votes
0answers
699 views

Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell

Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell. How can I avoid those extra quotes? Also, ...
0
votes
0answers
310 views

Query google spreadsheet and display single column?

I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to ...
-1
votes
0answers
17 views

Stocks Valuation google spreadsheet

I'm a bit of a dummy as far as spreadsheets go, so hoping someone can help with my dumb questions. I want to have a spreadsheet where I can list all my mid to large caps with the market cap in the ...
-1
votes
0answers
19 views

Concatenate values including column headers

I am using the following script that was kindly supplied in another answer : function mySummary(header, range) { var output1 = []; for(var i=0, iLen=range.length; i<iLen; i++) { var ...
-1
votes
0answers
21 views

Export data from sheet to already created sheet

1) Find Google Sheet (Sheet 1), 2) Filter by a Column for specific name, 3) Export filtered rows to an already created Sheet (Sheet 2), 4) Automatically update Sheet 2 when Sheet 1 is edited. ...