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

learn more… | top users | synonyms (1)

0
votes
0answers
22 views

Dynamic drop down in case of multiple cells for looking specific list of subsequent cells and choosing

How to use a dropdown in case of multiple cells in case of large data which I have posted at > https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/O5oKD2Afkp0 And Spreadsheet > ...
0
votes
0answers
32 views

Delete a q​uestion in a Google Form

I want to delete a row in the Google Form, and it disappears well enough in the spreadsheet, but it is still in the presentation. I also want to modify the contents of the investigation, but it does ...
0
votes
0answers
45 views

Pull data from one sheet (has a locked cell) to another sheet (has a locked cell) every day automatically?

I have a dynamic Google spreadsheet to which I add one more sheet every day. I want to take the data from sheet1 cell D96 (a protect cell) to sheet2 cell D3 (a protect cell) every day. I found a ...
0
votes
0answers
58 views

Sort all sheets by column 1 in first sheet

I’m trying to sort or autosort an extensive Google spreadsheet with various codepending sheets. I have tried to use the sort function but that is to blunt to use in this case. I’m hoping to get some ...
0
votes
0answers
33 views

Use a combination of the ARRAYFORMULA, SUM and arithmetic operations with wildcard characters

This is in further addition to the existing question at How can I refer to two different columns in a COUNTIF function? . The accepted answer worked like a charm. However, I have a requirement of ...
0
votes
0answers
39 views

Unique ID in Google Sheets to persist so it's not updated when row is updated via the form?

I'm using this: function onFormSubmit(e) { var sheet = SpreadsheetApp.getActiveSheet(); var row = SpreadsheetApp.getActiveSheet().getLastRow(); var bugCount = ...
0
votes
0answers
47 views

How can I synchronise the rows of a Google spreadsheet with Asana tasks?

My startup uses a Google spreadsheet for its client database (linked to a Google form, so that clients can fill their own data in if needs be). We also use Asana for our tasks and would like client ...
0
votes
0answers
40 views

How to create a simple dialog form in Google Spreadsheets with GAS

The functionality that I am going for is this: Click on a menu option Interactive box comes up with 6 textboxes that correspond with a label each In two of those boxes, at most three, a number is ...
0
votes
0answers
51 views

Google Spreadsheet Sub Columns/ Multidimensional data

So, I'm trying to create a spreadsheet to track and graph a rifle team's performance. One page with data, and the rest with the graphs. The data needs to be organized by the date of the practice, ...
0
votes
0answers
20 views

Charts does not follow page flow when printing

I'm trying to print a sheet with a bunch of charts. When printing it seems like the charts doesn't count as part of the page as the formatting of the pdf og printed page does not at all reflect how ...
0
votes
0answers
17 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
34 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
53 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
72 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
104 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
71 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
53 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
31 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
56 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
45 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
36 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
213 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
52 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
22 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
88 views

Continue formula on Form submission

I want the following formula to be continued on form submission: =ARRAYFORMULA(D2:D*E2:E+L2:L*M2:M+Q2:Q*R2:R) I came across =ARRAYFORMULA(FILTER(D2:D;D2:D<>""*1.2)) this formula works perfect ...
0
votes
0answers
434 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
29 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
29 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
28 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
31 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

“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
51 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
55 views

Auto receipt filler

I have a spreadsheet that has two sheets, in which I pull data from for making printable receipts. At this point, I am doing it manually by copying the data from the first and second sheet and putting ...
0
votes
0answers
73 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
51 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
43 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
140 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
246 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
23 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
90 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
37 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
67 views

Google Spreadsheets: referencing automatically cell data from a dynamic list of files

I have a a list of invoices created with Google Spreadsheet. Now I would like to retrieve the data inside of those invoices to create another spreadsheet called "All" that contains a row for each ...
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
63 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
110 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
166 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
83 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
74 views

How to automatically “start a new paragraph”\“full stop” in a cell ?

I have some problem to set the automatic start of a new line in a cell of a Google spreadsheet without press CTRL + every time that I want a new line in a cell. I have try to do as specify in this ...
0
votes
0answers
46 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 ...