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

learn more… | top users | synonyms (2)

2
votes
1answer
26 views

How to order category by numerical order with text in cell

I want to arrange my C column by numerical order, however the cells themself have text in something like "503 in Kitchen & Home", I want it to detect the number but ignore the string. Is ...
2
votes
1answer
28 views

Need to be able to refer to a sheet within a count function

I have a Google Spreadsheet I'm working on. Each tab has new data that's pasted in on a weekly basis, for example, I just created a new sheet called 5/5/2015 and included the data within. What I'd ...
2
votes
1answer
40 views

How to sort Google Sheets columns by row height

I'm working on a sheet that involves multiple columns corresponding to various data. Each column has a varying number of cells of varying heights with wrapped text. What I want to do is make the sheet ...
2
votes
1answer
40 views

Forcibly format column as Date in sheets onOpen() with Javascript

I have a simple sheet that gets some date data submitted via a form. The form works great, data is collected, but I have to click on the column, and do Format → Number → Date in order to get dates to ...
2
votes
1answer
23 views

How to consolidate information from different sources in Google Sheets

So I have a Google Sheet with several sheets (tabs) in it, like so: Sheet 1 - Weapons Legend A B C D A = Date 5/3 John Sword 10 B = From 6/3 ...
2
votes
1answer
24 views

How to apply formula to multiple cells without it adjusting part of the formula

I'm having a little bit of a problem and was wondering if your expert knowledge could help me out. Formula in question: ...
2
votes
1answer
21 views

How to work out the price of shipping an item in Google Spreadsheets

I'm currently trying to build a formula to work out a problem I have. What is the problem: Right now before I can send an item out, I need to work out how much that will cost me. This is done by ...
2
votes
1answer
21 views

Calling a date with =concatenate is resolving to strange number

Using: =concatenate("Review Check on ", B2) B2 is "4/20/2015", that I created using the date insert shortcut (command+; on Mac). The final cell resolves to "Review Check on 42114"—the “/”s have been ...
2
votes
1answer
49 views

Google Spreadsheet limit ArrayFormula

I'm using the ArrayFormula to calculate multiple ranges and it's slow because it's trying to calculate everything in that range, even though it has nothing in it. Is there a way I can limit the ...
2
votes
1answer
40 views

Make cell height in one column not affect other columns within the same row in Google Spreadsheets

I have done a schedule in Google Spreadsheet. I set text wrapping to wrap. The problem is that when I write something in column A and the row in column A gets expanded to fit all text all other ...
2
votes
1answer
33 views

Print text associated with a value

I have a Google Sheet that collects data and analyses any trends. What I'm trying to do is figure out how to output the text value associated with the numerical value. Example: Apples 7 ...
2
votes
1answer
77 views

Creating multiple time stamps on google sheets to make dependent drop-down boxes work

I read so many forums but cant find an answer to what is likely a simple matter. I need Time Stamps on 2 different sheets to make 2 different Dependent Drop Boxes work. I use the script below but can ...
2
votes
1answer
46 views

Apply formula when other is modified

I´m trying to create a spreadsheet to manage a business, in particular I want to use it to register the sales of the day. The problem i´m having in particular is that I need it to copy the price of ...
2
votes
1answer
704 views

Conditional formatting in Google Sheets: How do I check if a cell is blank?

In my exercise tracking spreadsheet, I want blank cells in columns B:O highlighted if column A is today's date, and the cell itself is blank. I have tried this: =AND(ISBLANK(B3),$A:A=INT(NOW())) ...
2
votes
1answer
560 views

Filter by Date Range in Google Spreadsheets

The filtering in Google Spreadsheets seems to only offer text based solutions. Is there any ability to filter cells by date ranges like any of the following: Today Yesterday Last Week Since ...
2
votes
1answer
36 views

Find first value in list in cell

I keep running into situations where I have a list of values in a cell in Google Spreadsheets, and I need some value out of the list: by list I mean a string of values (generally dates, but could be ...
2
votes
1answer
32 views

Is there any option to operate with 2 lists in one list in Google Sheets?

Is it possible in Google spreadsheets to have one list which is somehow divided into 2 parts and both of those parts consist of different lists? Something like iframes in HTML.
2
votes
1answer
61 views

Google sheet multiple column lookup

I have a table that looks like this: A | B | C ---|--------|--- 10 | Item x | 1 10 | Item y | 1 10 | Total | 2 20 | Item x | 4 20 | Item z | 5 20 | Total | 9 Now I would like to perform a ...
2
votes
1answer
161 views

Unique ID Column

I have a Google Spreadsheet that I want to have a unique number created in column A when I enter information in column B. Below is the formula I currently have that works, but I am wondering if there ...
2
votes
1answer
103 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 ...
2
votes
1answer
94 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 ...
2
votes
1answer
31 views

Importing a value from a webpage, and storing it as value, not a 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. ...
2
votes
1answer
55 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 ...
2
votes
1answer
191 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 ...
2
votes
1answer
246 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 ...
2
votes
1answer
137 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 ...
2
votes
1answer
117 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 ...
2
votes
1answer
77 views

Formula breaks subtly in ARRAYFORMULA in Google Sheets

I have a spreadsheet document with a formula comparing a list of URLs to lists on two other sheets within the document. I desire to know if each URL on the first list is present on the blocklist, ...
2
votes
1answer
63 views

How to grant a specific list of user to access Google Form?

Currently when I click on the "Send Form" button in Google Form and user will be able to input the form when they know the URL. Is it possible to grant a specific user to have access to the form? (So ...
2
votes
2answers
211 views

Conveniently export part of Google spreadsheet to HTML page

Google spreadsheet allows you to save table as HTML: The problem is that what the HTML you get is not publishable in website or coherent HTML document: I'd just like a part of the table as HTML. ...
2
votes
1answer
31 views

Select range by typing it in, e.g.,“f1:f600”

How do I select ranges by typing in the range value in Google Spreadsheets? I need to be able to select, say, d3:d1000, by typing in “d3:d1000” somewhere. In other words, what F5 does in Excel. I ...
2
votes
1answer
642 views

How to set Custom data validation in Google Sheets (A really simple step-by-step guide needed)

I'm trying to figure out how to create custom data validation in Google Sheets what are the steps I need to follow to achieve this? For example if I wanted the following validation: // Set the data ...
2
votes
1answer
27 views

I can't seem to be able to use Google LaTex integration

Google claims that they have allowed LaTex equations in Google Docs. According to the help page, the option should appear under Insert → Equation. Doesn't seem to be the case: So what am I doing ...
2
votes
1answer
762 views

How to make SQL JOIN of two tables with Google Spreadsheet?

I am just figuring out how to achieve an apparently simple problem. I use to have data as in database tables in my spreadsheets. It's simple data but I often need to use =QUERY function and would be ...
2
votes
1answer
39 views

Appearance of Forms I never created in Google Drive

I have some Google Sheets file which I copy and change monthly. I never used Forms, but they are appearing all the time in the Drive and are related to this G.Sheets file as you can see on the ...
2
votes
1answer
46 views

Collect data from dropdown list

I'm making an expense spreadsheet, to keep track of all my expenses. I have made a dropdown-list with different category (Rent, Food, Others etc.) these are put into C2 to CXX, in the next cell D2 to ...
2
votes
1answer
280 views

How do I refresh script results when a cell color is changed?

I have a Google Spreadsheet that contains a script to count a number of cells by color. The script works perfectly but seems like when ever I change the color of the cell, the count is not updated. ...
2
votes
1answer
238 views

How to prevent user from downloading my Google Sheets

I have made a few useful spreadsheets for my company. I want to put them on Google Sheets, so my colleagues can use it online to make inputs and get results. But I do not want them to know the ...
2
votes
1answer
139 views

How to get more than 1 question to populate the same field/column in the Spreadsheet?

I am looking for some way to get the submitted answers to 2 or more questions to populate in the same column in the response spreadsheet, but on the next row. e.g. When gathering data from ...
2
votes
1answer
209 views

Can I subtract a cell value in another cell that already have one in Google Spreadsheets?

Let's say that I have two cells A1 (time needed) and B1 (time spent). I want that when I enter a value in B1 the value of A1 will be reduced automatically. I want that in some way I could enter in ...
2
votes
1answer
61 views

Google Spreadsheet add rows until marker

I have a spreadsheet of the form ItemA Subitem1 5 Subitem2 4 Subitem3 7 <potential marker> ItemB Subitem 4 I want to sum the values next to Subitem to a total next to ItemA, ItemB, ...
2
votes
1answer
84 views

Consolidate List of Similar Data into Single Row in Google Spreadsheets

I have a Google Spreadsheet that lists donations given by constituents with a unique account number. Several constituents have made more than one donation in a given period of time listed separately. ...
2
votes
1answer
260 views

Google spreadsheet: execute function only once to prevent circular dependency

I'm trying to do something like this: a1 = if(a1 = "", b1 + 1, ) ... aN = if(aN = "", b1 + 1, ) b1 = max(a1,1) The idea is that column A has unique ID's, and b1 keeps the highest generated id ...
2
votes
1answer
181 views

Run script when clicked on picture in published Google spreadsheet?

I used the script underneath in Google Spreadsheet and added an image that when clicked upon runs the GOTOSHEETONE function to navigate to sheet: SHEETONE. So far so good. However, when I publish my ...
2
votes
1answer
52 views

How can I use a single column as a normalized data point with multiple choices in Google Sheets?

I find I often want to have a column that is meant to be one or more choices from a fixed set. E.g. a Codebase field in a dev roadmap spreadsheet, which might have choices like {DB, API, JS, CSS, ...
2
votes
1answer
150 views

SUM a column of values that whenever a cell is empty gets it from a default column

I am trying to sum a column of values but whenever a cell is empty then it sums the value from a default column. Example: +---------+---------+---------+---------+ | Default | A | B | ...
2
votes
1answer
68 views

How do I reference a cell from a Google Spreadsheet in a Google Document

I would like to create a Google Spreadsheet and reference a cell(-range) from that spreadsheet in a Google Document. Basically, I want the spreadsheet to be a variable holder where I can input data ...
2
votes
1answer
49 views

Is it possible to define user permissions on a sheet basis in Google spreadsheet?

I have a Google spreadsheet with 10 sheets. Is it possible to define user permissions on a sheet basis in Google spreadsheet? For example, on sheet 1, user X can edit but user Y can only view.
2
votes
1answer
1k views

How to make a protected range appear normal in Google spreadsheets

I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. ...
2
votes
1answer
232 views

Google Spreadsheets SUMIFS with Text Value of Cells

Is there a way to use the text value of cells with a conditional statement such as sumifs so that on one sheet I can have all the expenses # A B C 1 R. Tusk Travel ...