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

learn more… | top users | synonyms (2)

1
vote
0answers
36 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 ...
1
vote
0answers
200 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 ...
1
vote
0answers
61 views

Adding and deleting sheets in Google Spreadsheets

How can I restrict users from adding new and deleting existing sheets in Google Spreadsheets? Only the owner of the spreadsheet should be able to do that. Other users should not be able to do that.
1
vote
0answers
166 views

Importing only certain rows

I am attempting to create a spreadsheet based off another spreadsheet. I only wish to import certain rows based on the second column of the first spreadsheet. If that column contains certain users ...
1
vote
0answers
326 views

setDataValidation in google script not working

Have a problem with setting data validation rules in a google spreadsheet using apps script. Below are two functions, one is an onChange function which will be triggered whenever a user changes the ...
1
vote
0answers
64 views

Automating Google spreadsheet to transfer new info

I'm looking to setup a production line with Google Spreadsheets. Here's how I intend it to work: Our Sales Rep John has a spreadsheet specific to him only. He takes in sales leads, and inputs the ...
1
vote
0answers
473 views

How can I get a cell to change it's value based on another cell's color?

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...
1
vote
0answers
155 views

Relative paths to other sheets inside a Google Spreadsheet

I'm trying to put our food recipe collection into a Google Spreadsheet. On the first page we have an index of all the foods. Each recipe is located on a separate sheet. We would like to be able to ...
1
vote
0answers
317 views

Google Sheets: Reference one sheet from another, where the user may not have view access to the referenced sheet

This is what I'd like to do: The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using ...
1
vote
0answers
83 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
0answers
1k 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 ...
1
vote
0answers
674 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
0answers
465 views

How to tally entries by user, date

I am using a Google spreadsheet to track entries by several users. How do I measure their productivity per day? Or per hour? I have the timestamp field, a user field and other fields, but what I want ...
1
vote
0answers
584 views

How to protect table cells in Google Spreadsheets from myself (accidental edits)?

As in Microsoft Excel, I want to protect certain cells in Google Spreadsheet. This is possible, but asides from the fact that it is quite confusing to me, it doesn't seem possible to protect cells ...
1
vote
0answers
840 views

Google Docs capabilities

We've created a commission calculator to help our resellers work out what commissions they will receive on a deal. We built it in Excel 2010 but want to move it to a web based platform that will ...
1
vote
0answers
672 views

How to make a query with Google Spreadsheet, that returns rows if deadline is two weeks from today, one month from today, 2 months from today, etc

I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula: =QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 ) ...
1
vote
0answers
339 views

Google Sheet document using ImportXML doesn't Automatically Republish

I created a file that uses ImportXML to pull prices from a set of web pages, and bless me, it works! To stay updated with the changes in price, I ticked the "Automatically republish when changes are ...
1
vote
0answers
93 views

Filtering Form Feedback using Google Docs

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
1
vote
0answers
2k views

Table of Contents in Google Spreadsheets

I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents ...
1
vote
0answers
118 views

How to insert empty row in Google Spreadsheets when two rows are not duplicate?

I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?
1
vote
0answers
200 views

How to graph one column against another from multiple sheets in Google Spreadsheets?

I have a spreadsheet here: graph with one column against another from multiple sheets I want to graph the ascent columns against the distance for each of the three tabs on the graph. How can I make ...
1
vote
0answers
640 views

Can I precisely position charts in a Google Docs spreadsheet?

I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet I ...
0
votes
0answers
4 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...
0
votes
0answers
27 views

Is there such a thing as a “git blame” for Google sheets

I know that one can easily see the revision history of a Google Sheet. But then that's the same as running git log.. It shows shows a chronological order of changes to the file. I'm actually ...
0
votes
0answers
12 views

Create dynamic form with data from a spreadsheet

I'm trying to create a form that collects the questions from a spreadsheet dynamically. Example Table: Name Number Age Don yes no Andy no yes Marry yes yes The ...
0
votes
0answers
14 views

Is there a way to get the summary section from a form into a Google Doc

I've got a survey using Google Forms and it has useful graphs in it's summary section (under responses). How can I get these graphs into a Google Doc? I tried downloading the CSV file and recreating ...
0
votes
0answers
18 views

How to reference rectangular range using IMPORTRANGE in Google Sheets

sandwich answered this question. How can I use their solution: =IMPORTRANGE("KEY"; "Sheet1!G"&B7) to import a rectangular range? I've tried =IMPORTRANGE("KEY"; "Sheet1!G"&B7":H"&B8) to ...
0
votes
0answers
18 views

Google Docs - Sheets (COUNTA also includes cells with formula)

My test sheet: https://docs.google.com/spreadsheets/d/1g3J7fumAak3ffWTiCa3vjM32zf5xEqkeuOlyDM3tffM/pubhtml I assign asset tags to a store under the "Asset Tags" worksheet. I find the asset tag that ...
0
votes
0answers
14 views

Conditional format — copy format of another cell (Google Sheets)

I'm using Google Sheets spreadsheet, hope it's ok to ask about it here (in superuser). Chances are the methods to accomplish this might be different from Excel or LibreOffice, if it can be done at all....
0
votes
0answers
5 views

Google sheets: Automatically including new rows on separate sheet

I have a google sheet document with two separate sheets, Sheet1 and Sheet2. I want column A on both sheets to stay the same. Column A of S2 simply has ='Sheet1'!A2 for cells A2 on down. Let's call ...
0
votes
0answers
22 views

One form submit produces two updates to spreadsheet

I have an application in which a user submits a form, the data are logged in a spreadsheet, the form submit triggers a script that records the new data and deletes any previous form responses from ...
0
votes
0answers
10 views

Google Spreadsheets: add hours to date problem

I've encountered some kind of strange problem with Google spreadsheets. I've 2 cells, in one I've date, lets say its 10/10/2010, in 2nd one is hour, 12:00:00. I get those from input cells, but when I ...
0
votes
0answers
22 views

IMPORTDATA() with Google Sheets

I am trying to use the IMPORTDATA() function on Google Sheets. Initially I tried downloading yahoo finance data, which didn't work. However, I cannot seem to get the function to work even using ...
0
votes
0answers
27 views

Is it possible to link an Excel document to a Google Sheet?

I have an Excel file that needs to be updated weekly, but I also have a clone on Google Sheets that needs to have identical changes done each week as well. I currently am trying to use the =...
0
votes
0answers
19 views

Can you integrate a form with Google Sheets document?

I want to have a form that you fill, submit, then it updates a Google spreadsheet file. What do I search to learn how to do this? I cannot find info on doing something like this.
0
votes
0answers
16 views

Loop through columns in different sheets, comparing the values

I have three sheets. One is for the item senders, one is for the receiving of the items, and the other times compares the sent and received. For the comparison to work I need to loop through columns a ...
0
votes
0answers
27 views

Set a send email account in Google spreadsheet

I have 3 email accounts, two gmail (a "corporate account" and a work account) and one personal account not via gmail. We collect requests in a google spreadsheet, where I want to add a hot mailto ...
0
votes
0answers
21 views

Can I Add Multiple “Locations” to a single row for a Map Chart

I have a Google Spreadsheet that I am testing out the Map Chart with. I wanted to test two Charts, Org and Map. So I thought that a list of gods would give me both. However, I ran into a situation ...
0
votes
0answers
24 views

How to freeze a row until a similar row shows up on Google sheets?

I would like to make an effect similar to how for example iOS apps persist a table's row until someone has scrolled beside it. example This behavior happens all the time in iOS apps. You can see ...
0
votes
0answers
17 views

How to lock/protect rows/columns width in “Google Sheets”

Using Tools > protect sheets we can protect certain ranges/sheets from begin "edited". But I want to protect some/all of the rows/columns from being resized (a.k.a. lock width/height).
0
votes
0answers
48 views

Which of the functions INDIRECT or IMPORTRANGE slows down my Google sheet that most?

I have a master Google sheet that: Uses the importrange function to fetch data from 8 different columns in 8191 separate google sheets (files, not only sheets/tabs). To be extra clear: in this sheet ...
0
votes
0answers
16 views

How to only use the Google Drive interface (and not the Docs one)

After the switch from Google Docs to Drive I've been trained to do everything through the Drive interface which I now prefer to the Docs one. But for whatever reason the Docs interface is still ...
0
votes
0answers
21 views

Enable smooth scrolling in Google Sheets for large cells

Similar to this question regarding Excel.
0
votes
0answers
55 views

Can I filter or query an importrange in a single formula without importing the range multiple times or using a 2nd worksheet?

Title sums it up, I want to be able to filter an importrange in a single formula, can this be done without importing the range multiple timer in the filter? I want to do this without using a 2nd ...
0
votes
0answers
30 views

Your Time stamp code

I have copied and pasted your code to put a time stamp on a spreadsheet that I am working on and it is working great. Except the day is coming back as "56" for some reason and I don't know why. It ...
0
votes
0answers
35 views

How can I format nodes in a Google Spreadsheets organization chart?

Google Charts allows users to format organization chart nodes using HTML. (Awesome.) I can't seem to find a way to format organization charts in Google Spreadsheets. I'd already be happy having a way ...
0
votes
0answers
23 views

How to jump to a certain sheet when I click the hyperlink in Google Spreadsheets

How to prevent the hyperlink creating a new tab when opened? Is there a way for the hyperlink to 'replace' the current page - rather than open a new tab?
0
votes
0answers
102 views

google.script.run.withSuccessHandler not working

In my Google Sheet script's page.html, I have <input type="button" value="Apply" onclick="google.script.run.setAttributes('abc');"> where setAttributes() is a function defined in Code.gs. ...
0
votes
0answers
245 views

Importrange() Error: “Results Too Large”, how to work around?

I'm trying to Importrange() from a range containing 240,000 cells (40 columns, 6000 rows). The Importrange() function is erroring out with "results too large". What are the limitations of Importrange(...
0
votes
0answers
94 views

How Can I Protect Specific (More Than One) Ranges

I have 13 Spreadsheets sharing different people and every day i copy(or editors copy)from before day's sheet and the spreadsheet has lots of formula so i try to lock them for no one mess them but it ...