Tagged Questions
0
votes
1answer
74 views
Creating a class roster in Google Spreadsheets from a split result
A lecturer from the European School of Physiotherapy in Amsterdam stumbled on a particular script I prepared, hoping it would resolve a problem he had.
After having had a little chit chat, it turned ...
0
votes
1answer
46 views
Why would this Google Spreadsheet onEdit script be so slow (2 secs to change cells, 3 secs to update)
I've put together a script for a spreadsheet based on what I have seen here and other sources that should provide a simple username and timestamp function. I have another spreadsheet that uses a very ...
0
votes
0answers
31 views
Google Apps Script UrlFetchApp and password protected pages
I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
0
votes
1answer
35 views
Google Spreadsheet Timestamp for columns B & D?
Found this script on one of the questions answered in the forum what I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
0
votes
0answers
44 views
Google Docs - If cell equals a value then move row to different Google Spreadsheet
I've got a script that sorts a Google Spreadsheet when a value in a column is changed.
I'd like to add to the script the following functionality:
If the value for column E = "Complete" then the ...
0
votes
0answers
94 views
How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?
I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
1
vote
1answer
38 views
Creating multiple instances of a cell value in Google Spreadsheet
I have a Google Spreadsheet with the following data:
A B
-----------------------------
1 | Number of responses | Value
2 | 1 1
3 | 3 ...
1
vote
0answers
53 views
Set a Category Filter in a Google Spreadsheet Line Graph
I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
0
votes
0answers
47 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
47 views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = ...
1
vote
0answers
38 views
Looping through the range of cells to test the dates
I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match.
It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
3
votes
1answer
49 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
1
vote
1answer
67 views
Iterated variable (i) for argument on range in Google Scripts API
for (i=0; i<numItems; i++) {
var cell = sheet.getRange(12,i);
cell.setFormula(i);
}
This simple formula should go to every place on the column 12 where there is data, and replace it ...
2
votes
1answer
67 views
Google Spreadsheet Sort Two Columns
So I've found the following answer in regards to auto-sorting by one column, which works great
How can I make some data on a Google Spreadsheet auto-sorting?
However, my use case requires the sorting ...
0
votes
1answer
77 views
How do I Sum Thoughout Different Sheets
How do I create a reference to a defined interval in several sheets?
Something like this: =SUM(Sheet1:Sheet2!A1)
0
votes
1answer
37 views
Repeat range under each other in Google Spreadsheets
I have a range of two columns with year and dates. In another sheet I want to repeat this range for X amount of times under each other. How can I do this?
So for example I have this range:
Year | ...
1
vote
0answers
80 views
Create new document within spreadsheet and link
I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
1
vote
0answers
84 views
Shared Google spreadsheet: enabling app script to run as author
I created a spreadsheet that I'd like to share with anyone with the url.
The sheet contains several app script functions. These functions both change the content of the sheet and copy data to another ...
1
vote
1answer
247 views
How do I automatically update a cell in Google Spreadsheets to the most recently entered in the same row?
I am trying to have one column that will show the most recent thing i entered in the row. Example: I want B2 to be the same as D2 but once I enter something in E2 I want B2 to display that. And then ...
1
vote
0answers
56 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
0
votes
1answer
154 views
How do I get an onEdit script to run on a Google Spreadsheet for all users
I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited.
The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
0
votes
0answers
20 views
autosort script troubles [duplicate]
autosort script from @wolf was working fine but no longer...
any thoughts?
function onEdit(event){
var sheet = event.source.getActiveSheet();
var editedCell = sheet.getActiveCell();
var ...
2
votes
0answers
444 views
Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger
At the end of each row filled in, using a custom Google Form, I'm adding three more columns:
Date of creation
Unique ID
QR code (it is a list of computers)
Unique ID and QR code are unique. QR ...
0
votes
0answers
122 views
How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet
I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.
Problem: I need to take multiple company names ...
0
votes
2answers
348 views
how do I get named ranges in Google Spreadsheets to be more reliable/current?
I'd like to pull values from a named range into a calculation. I have this function:
function getNamedRange(n){
SpreadsheetApp.getActiveSpreadsheet().getRangeByName(n);
}
Seems pretty simple. I ...
1
vote
1answer
83 views
How can I apply a script to only one specific sheet within a spreadsheet
I have a spreadsheet with two sheets called Robin and Lucy.
I've made/found/mangled a script to sort the data on the sheet each time I add some data to column A
function onEdit(event){
var sheet = ...
2
votes
1answer
2k views
How do I mail merge from Google Spreadsheet to a Google Document?
With Microsoft Excel and Microsoft Word, it is easy to merge rows from a spreadsheet into pages in a Word file. This was traditionally used to make paper mailings. How can I do the same with Google ...
3
votes
1answer
495 views
More Efficient Filtering Script
I'm exactly one day into writing Google scripts. I've managed to write one that will filter data in a spreadsheet with 24 columns and, for now, about 900 rows.
The problem is, it's slow. Any ...
0
votes
1answer
153 views
How to re-use Google Apps Scripts in new Google Spreadsheet
I'm having an issue. Whenever I create a new spreadsheet, I'm not able to add a script I've already created. The list for recent projects or scripts is always blank. Anyone have a resolution or do I ...
2
votes
1answer
212 views
Google Scripts : How to distinguish Empty cells from Zero
I want to count a number of specific responses from a form where the response can be left empty, zero or any other number 'd'.
The following code:
var data = sheet.getRange("B2:L").getValues();
...
3
votes
2answers
235 views
How can I make some data Autosort in a spreadsheet on edit?
I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B).
I have used the following ...
2
votes
0answers
191 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
0
votes
1answer
488 views
How do you add a custom font size in Google Spreadsheets?
How do I add a custom font size for a Google Spreadsheet I have? There are some defaults like 14pt, 18pt, 24pt and 36pt, but I would like to have a font size like 30pt, is it possible?
0
votes
2answers
187 views
Selecting Values from separate sheets and aggregating the results with google spreadsheet
I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am ...
3
votes
1answer
164 views
Google Spreadsheet text cell formatting question
I'm trying to create some sort of automated formatting for certain columns (except headers of course.) to take a string of numbers (and previous formatting; which should be stripped.) and format it as ...
3
votes
1answer
319 views
Creating a function that runs when a Google spreadsheet is opened
I want to create a function which runs automatically when the spreadsheet is opened. This function will make the selected cell the last cell without text in a certain column. Basically, I don't want ...
6
votes
3answers
428 views
Sorting data in Google Spreadsheet by cell entry
I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this:
Each student may sign up for more ...
3
votes
1answer
585 views
Auto create and name new sheet in Google Spreadsheet
How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
1
vote
1answer
243 views
How can I dynamically format the diagonal cells in Google Spreadsheet?
I want all of the diagonal cells (A1, B2, C3, D4, E5, etc) of a Sheet to be formatted as Black Background, White Foreground. Is there any way to do this for a Sheet that constantly increases in size?
...
2
votes
2answers
3k views
How can I automatically set “last updated” cell in row Google Docs Spreadsheets?
How can I automatically set "last updated" cell in row Google Docs Spreadsheets ?
I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
3
votes
2answers
660 views
Parsing timestamp in Google spreadsheet with script
I have a spreadsheet with a form that timestamps every time the form is submitted. I'm writing a script to change the background color of the timestamped cell if it is more than 7 minutes after a ...
2
votes
1answer
380 views
How to Refresh a cell in Google Spreadsheet?
I have a column in Google Spreadsheet that calls an outside webservice using URLFetch in a Google Script. The cell uses two parameters in that cell's row. After a change occurs where those two ...
2
votes
1answer
185 views
Daily calculation and record insertion in Google Spreadsheet
I have a Google Spreadsheet that I am using to checkout last prices or levels of certain stock indices's. I have two worksheets in the workbook, one contains the indices's and a calculation I am ...
0
votes
2answers
821 views
Create a dropdown list of options from VLOOKUP
What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup.
Example
Here the data I'm using for reference. Notice "AAA" ...
2
votes
1answer
457 views
Google Apps Script - Want to email specific spreadsheet row data on event
Scenario
Basic support ticket clone:
Users submit a form (e.g. answering fault reporting questions)
Data is obviously stored as rows in the corresponding spreadsheet
I've added an onEvent trigger ...
5
votes
3answers
7k views
Alternating colors for lines in Google docs spreadsheet
I have a shared Google spreadsheet where several users have already filled out parts.
It would be useful to have alternately colored lines to facilitate correct placement of additional data.
Is ...
0
votes
2answers
802 views
Return an Offset Cell Value, Where Last Occurrence in Range is Matched
I have a worksheet like this:
|| A | B | C |
---++--------+-------+-----|
---++--------+-------+-----|
1 || 1 | a | |
2 || 2 | b | |
3 || 3 | X ...
7
votes
2answers
5k views
Text to columns conversion in Google Spreadsheets
How do you do a text-to-columns conversion in Google Spreadsheets?
For example, I have the following data string in one cell:
5,233,6,2,6,7,2,2,6,6
I want to break it apart by the comma separator ...
1
vote
1answer
377 views
Batch copying/renaming in Google Docs
I need to copy and rename a base form (a spreadsheet) to several other forms in Google Docs. Imagine I have the following form:
My Base Form - @name (@course)
After running the script or whatever, ...
1
vote
2answers
2k views
Parse HTML through Google Spreadsheet using scripting
I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting.
I remember Microsoft Excel had the import data function, but I don't own a copy ...
