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

learn more… | top users | synonyms (2)

1
vote
0answers
315 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
81 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
950 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
629 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
419 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
547 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
789 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
654 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
307 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
89 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
1k 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
116 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
190 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
572 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

Bound Scripts in Google Sheets on iPad and Android Apps

I created a Google Sheet with a bound app script on my desktop but the scripts do not run on the iPad or Android apps for Google Sheets. Does anyone know if this can be done?
0
votes
0answers
6 views

Join several columns with a single formula returning an array

This is the opposite of my question Split a column of strings with a single formula returning an array. I have several columns, say, A-K, which I want to join into one comma-and-space separated column ...
0
votes
0answers
23 views

How do I print a Google Docs document directly from Firefox?

Using Google Docs/Spreadsheet. If I open a Google Doc and select print (either via the menu, ctrl+p, or toolbar icon) from within Chrome or Opera it then opens a print preview screen where I can ...
0
votes
0answers
25 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
33 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 ...
0
votes
0answers
33 views

Selecting and unselecting checkbox not updating response sheet

I have a Google Form and a response spreadsheet that is updated as soon as a recipient of the form answers and submits the form. I have several different types of field ( multiple choice, grid, ...
0
votes
0answers
28 views

Automatically (when created) import PDF from Google Drive into Google Sheet

I use the Google API to "save emails and attachments" so when I get an email message it saves a PDF file into Google Drive. I also use Cometdocs PDF Converter to convert the PDF file to a Google ...
0
votes
0answers
29 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 ...
0
votes
0answers
24 views

Google Sheets permissions issue regarding editors

I have several users who when they are given access to Google Sheets they can't edit the sheets. They can comment and view fine but are not able to edit and input data into the sheet. I've cleared ...
0
votes
0answers
31 views

How to Resolve the Mismatched Row Size in Google Sheets?

I am trying to figure out what the mismatched row size error means. I cannot find a description of what that error means? I have an array formula that pulls data from a responses spreadsheet (from a ...
0
votes
0answers
16 views

Using Countifs to count the number of events happening some time ago

We run a series of courses. Each applicant has a date they started the course - eg 07/05/15 (UK format). What I'd like to do is countifs the number of applicants who started on a course more than x ...
0
votes
0answers
11 views

Can a sheet validate that a local file (referenced in cell) exists?

I think Google Sheets, as with most (all?) browser apps, is sandboxed so this may not be possible but... Is there a way for Sheets to validate a local file path referenced in a cell (file exists? ...
0
votes
0answers
36 views

Spreadsheet: How to calculate a percentage with a circular reference

I want to calculate a percentage of profit where the percentage is an expense and therefore affects the profit. Let's assume: Revenue 100,000 Expenses 50,000 Profit Percentage 50% Normally the ...
0
votes
0answers
13 views

Export a value of a drop-down box in a web page to a specific range (or a drop down box ) in a spreadsheet

I have a spreadsheet (name dada) with a drop-down list (named:"monthlistdada", we can choose Months : january, february , march .....) then it gave a schedule for different people. I made a site with ...
0
votes
0answers
29 views

Google Sheets How to change Recalculation “On Change & Every Minute” to Every Second?

I need create count down clock refresh second by second . function "=now()" only can change every minute but I need refresh second by second please help me
0
votes
0answers
27 views

Google Sheet Cell to have Clock to Pick the Time

How do I make a cell show a clock to pick / click on a time from a clock face to then add that time to a cell without having to type the time value into the cell.
0
votes
0answers
15 views

How to detect previously deleted Google Calendar events

Per this article, Google Calendar events are not really immediately deleted. Therefore, previously deleted events are successfully returned by the methodcalendar.getEventSeriesById(eventId) I need ...
0
votes
0answers
60 views

How can I plot date vs time in Google sheets?

I have a Google spreadsheets with two columns. Column A contains dates and is formatted as date. Column B contains times and is formatted as time. I want to make a chart showing the dates on the ...
0
votes
0answers
24 views

Linking to a specific Google sheet after it has been published?

Currently I have a Google spreadsheet with multiple sheets. I want to be able to link to each of these sheets separately so that I can have an index sheet people can just refer to. I know that within ...
0
votes
0answers
15 views

Subtract Data for Graph in Google Sheets

I'm pulling data into Google Sheets via the Google Analytics plugin, and the report runs automatically, replacing the data on a sheet called Website I then (on a different sheet) have various graphs ...
0
votes
0answers
101 views

Trying to send email from Google Sheets with image attachment

I'm trying to send an email from within Google Sheets and then format it via some joins to send to an address for my Blogger account. I need to attach the image file apparently as the image isn't ...
0
votes
0answers
225 views

Custom functions: Keep getting “There was an error during calculation”

I'm using two custom functions but for some time now I keep getting the following error when I load my sheet: There was an error during calculation; some formulas may not calculate successfully. ...
0
votes
0answers
131 views

Google Spreadsheet, Google script, calculate

I want to grade my students and give them feedback. So they make an excercise, I will give them the feedback if they do it perfect or not perfect. I want also give them grades. Question: So I have ...
0
votes
0answers
18 views

Google Spreadsheet Time of Edit

I'm currently working on a file with my team. I would need to add a script that returns the following: For a specific column of a specific sheet, when was it edited and by whom into a comment for that ...
0
votes
0answers
84 views

How to make Sheets recognize worksheet tab colors from imported Excel workbook

I have some workbooks I'd like to upload to Sheets. Pretty much everything, from formatting to filters, makes it over reasonably well from Excel to Sheets except for one glaring exception: worksheet ...
0
votes
0answers
110 views

Auto-update Google Client Sheet when Master Sheet is update

I have a Google Spreadsheet (Master Sheet) which pulls in data from Gravity Forms entries via Zapier. Within this spreadsheet there are 5 different worksheets. The main worksheet which contains all ...
0
votes
0answers
41 views

How to plot a graph with random time intervals in Google Spread Sheets?

I want to create a line chart using a hours of the day on the Y axis. My data appears at random time intervals, eg: 9:00, 9:35, 10:35, 10:50, 11:30, Is there a way I can incorporate this into a ...
0
votes
0answers
31 views

Send to respondents a number between 1 and 10 using Google Forms?

My idea is to give to respondents by mail a number reference between 1 and 10. The idea works as follows: You have 10 boxes. When a response is submitted, automatically the form will send a email ...
0
votes
0answers
344 views

Google Sheets: Error- Array result was not expanded

For cell J129 I'm using the following formula =index(B122:122,1,counta(B122:122)), but I keep getting an Error that says, "Array result was not expanded because it would overwrite data in K129." I'm ...
0
votes
0answers
76 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
0answers
121 views

Formulas mix up references when sorting data in Google Spreadsheet

I have a Google Spreadsheet that has formulas embedded into various cells. When I sort the data, the formulas always get messed up, and no longer pull data from the proper reference cells. How do I ...
0
votes
0answers
42 views

Google Sheets Query Formula Needed

https://docs.google.com/a/fivetowns.net/spreadsheets/d/1myKz4WpRAt3Kja__Dsddnr3YtfOjVPkYUOTXoi-4exc/edit#gid=1665161315 Above is link to mock up of my spreadsheet. I would like to build a formula ...
0
votes
0answers
382 views

Google Sheets trendline broken; file unavailable

In Google Sheets, I've created a line graph. I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown. No trendline appears. Then when I right ...
0
votes
0answers
60 views

How do I get choose a Named Range in Gsheets from a drop down (autocomplete, etc.)

I'm using Named Ranges in google Sheets but it's a real pain to have to type the name exactly right, esp since I'm using very verbose, descriptive names. So, I'm wondering if there is any sort of ...
0
votes
0answers
119 views

Google Spreadsheet Script: insert text at end of list

I'm trying to add a custom menu that inserts a date in whatever cell is selected, appending it if anything is there already. It works fine, if slowly. The goal is that, at the end, I've got a list of ...
0
votes
0answers
61 views

Unable to import pricing info from toysrus.com into a Google Spreadsheet

I'm trying to pull live pricing from a given toysrus.com item into a Google Spreadsheet (one item/price per row), and am having no luck whatsoever. Importxml(url, xpath) does not work (similar to the ...