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

learn more… | top users | synonyms

0
votes
0answers
26 views

If statement to input the next integer

I have a row of values that sometimes returns a value, and sometimes doesn't. I want to input the first number that is actually a number. Sheet Value Indicators Column A Column b ...
0
votes
0answers
12 views

Why don't the Google Spreadsheet notes line up after several sorts?

I inserted notes into my Google spreadsheet to add comments. For several weeks no problem. Now I've discovered that after several sorts in various ways, e.g., date, name, city, etc., the ...
0
votes
0answers
37 views

How to Embed google map to your google spreadsheet

Suppose i have the following columns in my Spreadsheet Lat/Long | Tooltip [lat,long] | Some text goes here I know, it was possible to embed Google map (using gadget [deprecated]) to your ...
0
votes
0answers
28 views

How do I allow a user to edit a specific column only?

I have a protected range but I want to do the opposite of its function. I only want a user to be edit that specific range. So, how can I have them "view only" for the whole spreadsheet but edit one ...
0
votes
0answers
48 views

Import info from multi tabs in a spread sheet to one sheet

I'm looking to move data from "sub sheets" to the main sheet. I know I've done this before but it's been 5 years since. So here's what I'm looking for: ...
0
votes
0answers
66 views

Google Docs update values on a 2nd spreadsheet and automatically links and updates values in the 1st spreadsheet

I have 2 spreadsheets. Spreadsheet 1, the initial data is entered manually. I do an importrange into spreadsheet 2 with a order by Col2. This is what I get when I perform importrange (sort on ID) ...
0
votes
0answers
68 views

Custom field names in form linked to Google Spreadsheets

I would like to use Google Spreadsheets to store responses from a custom form. The name attributes of the input fields appear to be randomly generated (entry.<random num>). Is there anyway to ...
0
votes
0answers
82 views

Pass range in Google Apps script custom color sum function without using A1 notation

I want to sum up lines with Google Spreadsheets where the cells have a certain color. Since it needs to be copied down I want to have a function that doesn't use the A1 notation. There is already a ...
0
votes
0answers
44 views

Merging two lists with common entries in Google Spreadsheet

We're populating two separate worksheets in a Google Spreadsheet, through 3rd party integration. In essence, we're collecting customer information through a Wufoo form and their payment information ...
0
votes
0answers
40 views

Why does my Spreadsheet keep automatically adding rows?

It probably has something to do with my Array formulas. I'm guessing but why does it seem like whenever I input a value in one of the column's cells, it would keep adding rows automatically? It also ...
0
votes
0answers
22 views

Count occurrence of names separated by quarter

I'm building a quarterly count sheet from a log sheet ('2014 Sanction Log') in the same spreadsheet where L:L is where the names exist that I want to count the occurrence of and A2 is the name on the ...
0
votes
0answers
52 views

How do I sort forms individually based on individual events in Google Forms?

My purpose is to conduct 5 events, namely 1,2,3,4,5 say ... I'm using a Google form to accept responses from people. Emails are sent to people automatically and they can register for more than 1 ...
0
votes
0answers
29 views

Data validation from other Google Spreadsheet

My scenario : Google Spreadsheet A Google Spreadsheet B I want a Data Validation in one cell in Spreadsheet A that it's criteria is based from a list from a range on the SpreadSheet B. I know ...
0
votes
0answers
32 views

Add Drop Down Boxes into total

I'm trying to style this sheet better so a user can select items from Everquest Next Landmark and get a total of all the items needed to craft it all. Basically if they want to add up a copper ...
0
votes
0answers
193 views

Populate Google Form field from spreadsheet to generate unique url

I have a customer satisfaction form that I am going to send out to multiple people. I'd like to link that survey to a unique incident number. Each person can fill out a survey multiple times for ...
0
votes
0answers
44 views

Work around app script for notifications on new google spreadsheet

I need a work around app script for notifications on new google spreadsheet. I would like to have an e-mail notification sent to me if someone makes changes or additions to column D.
0
votes
0answers
19 views

Assistance with my 1st Script to run inside Google Spreadsheet

I need a simple script to run in a Google spreadsheet that takes the text in cell A7 (which is a formula but without the equals sign in front of it, so the sheet treats it as text. And puts it in ...
0
votes
0answers
337 views

Create a checkbox-type function that works on the Android Drive app for Google Spreadsheet?

How can I create a checkbox-type function that works on the Android Google Drive app for a Google Spreadsheet? I want to make a to-do list (groceries, trip prep, etc.) that the user can check "done" ...
0
votes
0answers
22 views

Google Spreadsheet print column-wise

I want my Google spreadsheet to import data from another Google spreadsheet. And I have successfully done that. But now I want to design a game in which I need the data to be imported and written ...
0
votes
0answers
25 views

forms automatically generate individual sheets

Is there a function which will allow data submitted via forms to create an individual sheet within my master file, in addition to being incorporated into the master list. For example, in the data ...
0
votes
0answers
18 views

Google Sheets Custom Sort

I need help creating a script to select only rows 15 to 630 (a15:z630) of my "DASHBOARD" page and sort these rows by column A (date). The first 14 rows are frozen and must never be sorted. ...
0
votes
0answers
29 views

'New Row' Spreadsheet List function

I have set up a Google Docs Spreadsheet to use as a job booking in system for my design agency. I'd like to have this where the newest jobs are at the top, but at the very top is a blank row, where a ...
0
votes
0answers
64 views

Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
0
votes
0answers
41 views

“ImportXML” function in Google spreadsheet for “answers.yahoo” site

Please help me understand why this formula =importXML("http://answers.yahoo.com/search/search_result?fr=uh3_answers_vert_gs&type=2button&p=cloud","//ul[@id='yan-questions']") is not ...
0
votes
0answers
45 views

Error in Query function with aggregate function in two column & Pivot

I have an error while using query function which I have used in “Solution” Sheet. Below is the function that I have used: =QUERY(Problem!A6:G3493,"Select C,sum(F),Sum(G) group by C Pivot D label C ...
0
votes
0answers
56 views

List of Dates of Current & Previous Month in Google Spreadsheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
0
votes
0answers
49 views

Import Google SpreadSheet data into Google Adwords via a script

Google Adwords data can be exported to a Google SpreadSheet, by using a script. How can I import Google SpreadSheet data into Google Adwards, with the usage of a script? I've gone through the API ...
0
votes
0answers
35 views

Google Sheets Function to have a button take you to a specific sheet

So I followed the instructions to make a function as found here. But when I click the button I made, it takes me to the correct sheet but all the data is hidden. In this example I clicked the ...
0
votes
0answers
132 views

Index Match Script for Google Spreadsheet

I'm making a scheduling database in Google Drive. On a second sheet in the same Spreadsheet I have all accounts listed in columns: I would like on the 1st sheet to type in an account number in ...
0
votes
0answers
202 views

Prefilled Google Forms with Google Spreadsheet Data

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question ...
0
votes
0answers
20 views

Is it possible to link an editable Google Spreadsheet in to Google Coursebuilder?

Is it possible to link an editable Google Spreadsheet in to Google Coursebuilder? I see that I can add a Google Spreadsheet into the lesson body using the rich text editor and adding the gcb: Google ...
0
votes
0answers
72 views

Google Spreadsheets formula error

I have the following formula in a sheet that works in Excel but comes up with an error in Google Spreadsheets. =(IF(A6<=TODAY(), INDEX($AS$2:$AU$12,MATCH(A6,$AS$2:$AS$12,1), ...
0
votes
0answers
33 views

Is it possible to create a form in an HTML component in an edX unit that sends parameters to Google Spreadsheet

The edX platform doesn't have functionality to create poll style questions. I would like to create a form in an html component of a unit that saves the input from the form into a spreadsheet as a ...
0
votes
0answers
59 views

Spreadsheet Data into a Form

I am building a simulation (a "create your own adventure") for my students in which they use a Google Form to select into which of 5 groups they would place 25 first graders (Round 1). I get the ...
0
votes
0answers
52 views

GAS: How to change all values of a neighbor column? (code not working)

I have a Google Apps Script which I want to use to do this: get the text of all cells of column G of my sheet, extract some data from this text (dates embebed in text) and put the result in the column ...
0
votes
0answers
87 views

Prevent sorting within a strict subset of the columns

For Google Docs Spreadsheets, is there any way to prevent sorting from ever being carried out in just a strict subset of the columns, so that data in some of the columns remains stationary while data ...
0
votes
0answers
30 views

get editor name, time stamp, and date after every editing

I have a spreadsheet, on that every cell i want the name of user, new time and date on which the editing done. the formate will be "date, time stamp, and update by" Kindly suggest
0
votes
0answers
81 views

Can any Excel spreadsheet function enact a certain $ transfer between $ accounts?

I can't yet find an Excel spreadsheet function to enact a certain transfer of money (between e.g. two Paypal or bank accounts) ; does anyone know of one? (Usage example: Of course, this function ...
0
votes
0answers
135 views

Filtering data based on dropdowns in Google Forms

Is it possible for me to have a choose from a list question in a Google Form and have two dropdown boxes? Such that, the list items in the second dropdown box will depend on the item chosen in the ...
0
votes
0answers
75 views

Sending emails to specified end users

I'm trying to write a script to send emails from a google spreadsheet. My specifications are: Send email upon form submit Only send to email address listed on form I have written a sendEmail ...
0
votes
0answers
36 views

How to restrict the number of entries for a particular column in shared spreadsheet using Google Drive

I want to create a spreadsheed using Google Drive in which some columns entries should be retricted based on given value. E.g.: I have some columns named users, item1, item2. In columns item1 & ...
0
votes
0answers
43 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 ...
0
votes
0answers
111 views

Use of importdata with arrayformula

I’m using importdata to retrieve Yahoo stock information, which works fine on indivdual rows, but when combined with arrayformula to fill down the page when additional symbols are added does not ...
0
votes
0answers
62 views

Google Spreadsheets Validation list with Label

Thanks in advance. I have just started using Google Spreadsheets so am very new to it's ways! So far it looks incredibly powerful! I am using some data in a sheet called Jobs as a reference to ...
0
votes
0answers
45 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 ...
0
votes
0answers
39 views

How can I move the cursor when editing a formula in Google Spreadsheets?

The cursor control while editing a formula in Google Spreadsheets on Mac OS X is maddening! Left and Right move the cursor one character left and right Option-Left and Option-Right insert a cell ...
0
votes
0answers
191 views

Fill a Google Drive Document from Google Drive Spreadsheet

I would like to have a template document and fill some fields with data from a spreadsheet, for example changing the id or name of an entity in the template and automatically the document updates all ...
0
votes
0answers
497 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
0answers
388 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 ...
0
votes
0answers
35 views

How to set hot keys to a customized menu item in a Google Spreadsheet?

I am working with Google Spreadsheet APIs, and found that customized menu item is highly useful. I created some but am now wondering whether I can specify a hot key for each?