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

learn more… | top users | synonyms (2)

2
votes
1answer
79 views

What is the key in my Google Spreadsheets URL?

I have found many posts from awhile ago that talk about the <key> in the URL. Problem is when I am trying to input the key, there is none. Well at least I cannot determine what the key is. ...
2
votes
1answer
42 views

google cell format: only 3 digits

Is there any way to do this: I have cell and most of the numbers have 2 significant digits like 3.45. But once in a while I have a number like 143 big number, the rest are under 10. Currently for 143 ...
0
votes
0answers
22 views

Formula for getting format of a cell in Google Sheets [duplicate]

I'd like to be able to return formatting information about a cell with output similar to that of the CELL command. Ideally, this would be something like CELL("format", A2), and if A2 was bolded, or in ...
1
vote
2answers
96 views

How to sort cells with text and numbers correctly

This is my example list: example file As you can see I am sorting all unique elements in row B. But the "Sprint 9" gets sorted as the highest value, not the lowest. I really have no clue how I can ...
1
vote
1answer
194 views

Get duration as seconds google spreadsheet

I'm calculating some sums of gain over time - therefore I want to divide X by time required to generate X. The problem here is, that the SECOND function in the =(SUM(B4:B18)/SECOND(SUM(A4:A18)))*60 ...
2
votes
1answer
81 views

Import a CSV file from a URL to Google Sheets and update it periodically

I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to ...
1
vote
1answer
69 views

Dynamic date range query

I'm trying to create two cells that will update my query: A >= date"A1" and A <= date "B1". My goal is to create a search page for the data, where the end user could insert a date or the =today() ...
2
votes
1answer
79 views

How do I loop a script through all pages but the first one?

I'm very new to all this. I'm trying to write a script that sorts sheets by descending date order each time a new row is entered. I need the script to run on all pages but the first (the summary ...
4
votes
1answer
136 views

How to have multiple users complete a single form in Google Forms

Using Google Forms, is there a way to have a user complete a section of a form, share the form and have another user complete another section of the same form, thereby keeping the combined inputs as a ...
1
vote
1answer
81 views

Google Sheets IMPORTRANGE + QUERY won't import IMAGE

I use Sheets in my business to create product catalogs for wholesale prices. I have different sheets for different companies but the data in many of them is the same. I'd like these sheets to sync ...
3
votes
2answers
134 views

Join two columns in Google Sheets

I have two columns in Google Sheets, and I would like the product of a cross-join: Student ------- Jake John Sally Grace Days ----- 1/1/15 1/2/15 1/3/15 1/4/15 For example, if these were tables ...
1
vote
0answers
22 views

Google spreadsheet: Pasting value not function

I am writing a spreadsheet that imports values from webpages that change a lot, I want to keep note on these values over the days of a week. However I'm unsure of how to note them at certain times. ...
1
vote
2answers
131 views

Google Spreadsheet criteria if cell above is blank

I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the column above. Consider the following example: A | B | C --------------------------------- ...
1
vote
1answer
61 views

Auto sort a column and auto duplicate all sheets to one sheet

The title speaks for itself. I am looking to do two things in Google Sheets, because I am entering data from a different third-party app using Google API. First: I need Google Sheets to auto sort a ...
3
votes
1answer
196 views

Google Sheets auto-format the highest value in a row of cells

I have a set of data like so: A|B|C|D 1 9|3|5|4 2 7|6|6|6 3 3|6|2|7 4 6|9|4|7 And I would like to auto-format the highest value in each row. So, for instance in row 1, A1 would get the ...
2
votes
1answer
50 views

Calculate total based on drop down criteria

I am creating a budget that has different expenses on one worksheet (Expense_Overview). On another worksheet, I have a list of expenses (Expense_Detail) I am entering that are categorized based on a ...
0
votes
0answers
35 views

Automatically creating sheets across different google spreadsheets

I have one spreadsheet that collects the Google form data that is submitted. I then created spreadsheets titled "A-D", "E-H", "I-L", and so on to create the alphabet. I would like students to use ...
3
votes
1answer
43 views

How do i move an image/chart to a corner in Google Sheets without the awful margin?

I'm trying to get this image in a corner: As you can see, when trying to move, Google puts an awful margin on the top which makes impossible to get an image on the very top of a document. Any ...
0
votes
0answers
48 views

Automatically create google spreadsheets from master list

I am trying to create new sheets automatically based on a list of items. I came across your answer to a question here , but the example sheet it points to is no longer valid. I am working with this ...
0
votes
0answers
136 views

How to copy permissions across sheets?

Named ranges are duplicated when their sheet is duplicated. However, protected ranges are not. I have 40 protected ranges on a sheet that I need to replicate 6 times, so I'm not really looking ...
4
votes
1answer
43 views

Is it possible to embed a Google sheet's in a non google-site website?

I'm creating an internal site for my users and I don't want to be constricted by the limitations of hosting a site through Google sites. But I also want to be able to embed Google documents and ...
1
vote
1answer
83 views

Linking a URL to text using google script in spreadsheet

I have a URL ready to be followed. I am sending an email using Google script, and in this email I need this link to be there... but I do not want it to be: ...
2
votes
1answer
159 views

Google Sheets importrange every x hours

I want to link 2 spreadsheets with importrange let's say A with B. B is the source. I want A to import numbers from B every 6 hours, because the numbers in B are constantly moving and since the sheet ...
0
votes
1answer
50 views

How do I do simple time calculation in Google Spreadsheets?

I have a really simple question, I have searched online and for the life of me, cannot work out how to do this: Calculate the total hours and minutes from a start time to a finish time? Calculate ...
1
vote
3answers
102 views

Conversion from object to string in google scripts

I'm trying to take information from Google Sheets and use it to send an email with the information given in sheets. I have the email part down, but when i try to editAsText to delete unwanted ...
2
votes
1answer
164 views

How to generate a random string?

I need to create a random string of 8 characters for every row in Google Spreadsheet. Basically string should contain letters and numbers upper and low case only, example: LZJ2cuWT Any idea how to ...
1
vote
0answers
91 views

How to change default row height of a migrated Google Spreadsheet

The old Google Spreadsheet has a default row height of 17. The new Google Sheets has a default row height of 21. After a spreadsheet is auto-migrated by Google to the new Google Sheets, the original ...
1
vote
1answer
19 views

Have indirect update row when pasted on new rows

According to this answer, I am fetching data from another sheet over rows: http://webapps.stackexchange.com/a/24478/29203 The problem for me is as I am fetching over rows, the supplied answer does ...
0
votes
1answer
26 views

Parse error with =IF function

I put this in: =IF(A4=2;1,(A4=4;7,A4)) and it keeps coming up with a parse error and I have tried to switch ; with , and it still didn't work. How do I make this work?
2
votes
1answer
50 views

How to enter a date in a cell and have the date for one week later automatically fill another cell?

I want to be able to type in a date in one cell, and then automatically have the date that is seven days from the date I typed appear in another cell in that same row under a different column. How do ...
0
votes
0answers
77 views

Formula query to perform dynamic sum

I am creating a spreadsheet which looks up values from a second sheet. I need to SUM various sections in the sheet but these are variable - the row that needs SUMing can change at every fresh import ...
4
votes
1answer
55 views

Insert a datatable directly under my chart in Google Spreadsheets

How do I create a data table directly under my chart on Google spreadsheets? I want to achieve something similar to the figure below. In MS Excel it is called datatable and it is inserted by a click ...
1
vote
0answers
38 views

function to verify all cells in active row

I have a function which is triggered onEdit to enter an ID in new table entries: function IdGenerator(e) { // Get the active sheet var sheet = SpreadsheetApp.getActiveSheet(); // Get the ...
1
vote
1answer
15 views

How to set a formula for a entire column?

I need to apply a simple formula into a entire column, this is to prevent having to keep pasting the formula into said column when i add a row... =IFERROR(D1-C1) is the formula that i want to ...
2
votes
1answer
111 views

How do I get a weekday 12 weeks ago using in a Google script?

I'm having the following formula: =TODAY()-WEEKDAY(TODAY(),3)-84 and this gives me Monday, 12 weeks ago. I'm working on this code, but it gives me only a certain days back var twelweWeekAgo = new ...
0
votes
0answers
23 views

Google Spreadsheets “Share with others” notification popup

How can I disable or stop from appearing the “Share with user” popup? This notification appears each time I start my script and only on one user, which already confirmed the sharing invitation.
0
votes
0answers
37 views

Freezing formula values in Google Spreadsheets

I have a spreadsheet that will receive new values pulled from an email via Apps Script once a day. I'd like to be able to "log" certain values over a specific length by loading them into a new cell ...
2
votes
1answer
291 views

Google Sheets - how to VLOOKUP in a QUERY

I Have this sheet with raw data, basically names, dates, amounts of money and if they paid or not (this is the most important). What I am trying to do is to have in another sheet the same table but ...
-1
votes
1answer
118 views

Numeric before query, query results not a number

I have a column of values, let's say column A, that if I do =isnumber on any of the column data it returns TRUE. Now after I =query and select A, the query gives me the right values, but the type ...
1
vote
0answers
65 views

Help me check if this URL is ok to query with Google Chart

For the last couple of hours been trying to get this work. I setup a demo sheet with just two colums: Name Value A 22 B 33 C 44 D 12 And want to plot it. I put this URL into ...
0
votes
0answers
25 views

Query in google spreadsheets

I have the following problem: In Sheet2 I have some dates and names like: A B C D E F G .... March April May .... 1 2 3 4 5 .... 1 2 3 4 ...
1
vote
1answer
274 views

Auto increment ID in Google Forms

I am designing a Google Form for managing a congress registration process. I need to have a unique ID number for each registration and I found an answear here: Can I add an autoincrement field to a ...
3
votes
1answer
105 views

How to show “Last edited” date and user on Google Sheets?

I've got a Google sheet that is updated quite regularly by a few people. I'd like to be able to view the doc, and at a glance—have a cell that shows a date (last modified) and another cell (user that ...
1
vote
2answers
44 views

Google Spreadsheets: Using conditional formatting from date in another cell

I have two columns side by side containing dates. The dates in column A are based on when a project is due. The dates in column B are based on when a project is completed. What I want to do is show ...
0
votes
0answers
13 views

Google Spreadsheet forcing time format to non English language

I have created a sheet that has time point displayed for each record. Example: 2:30 PM, 4:30 AM As my sheet is going to be used in India, I changed location in the setting and right after that, it ...
2
votes
1answer
94 views

Google spreadsheet formula using If() And() Or() Statement

I need help with a Google spreadsheet formula. This is what I'm trying to do: If (A3 = X) and C3 is not any of the following choices in this list ("Ready for QA Testing on Stage","Deployed to ...
0
votes
1answer
51 views

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
0
votes
0answers
57 views

How do I transpose data in a Google Spreadsheet and keep the formatting?

If we select a empty line and we type: =TRANSPOSE(A1:C27) We will invert everything from A1 to C27. However, formatting will be lost. Is there anyway to keep the format too?
1
vote
1answer
133 views

How to combine and consolidate rows from multiple sheets into one and sort them?

I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. So I'd like to generate new sheet which will populate rows from ...
1
vote
0answers
11 views

Detect column D changes with Google Apps Scripts

I would like to detect if the column D rows in my spreadsheet are becoming a date (at the beginning those column rows are empty), so if D1, D2, D3 become a date their text or colors should blink. Now ...