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

learn more… | top users | synonyms (2)

1
vote
0answers
5 views

Copy data from one sheet to another based on certain condition

I want to get all the Timestamp of an employee (EmpID) from one sheet to another using Google apps script or otherwise. Explanation In Google Sheets, Sheet1 has the following items in 3 columns | ...
5
votes
1answer
46 views

How to open a Google Sheets file and go immediately to the end of the file

I have a Google Spreadsheet with 100 lines. Every time I open that file, I want to insert a row on the end of my table. How can I jump to the last line of the table when I open the doc? Because ...
1
vote
0answers
9 views

Different bar types based on column value

Instead of having one column for each new "type" below, is there any way to achieve the same result using the non highlighted cells in the image below? To elaborate, I would like different bar types ...
0
votes
0answers
11 views

Add days of the month to a chart [duplicate]

I have 2 columns, a boolean value (nok/ok) and a date. I am tracking in which particular date I have completed a study module(s). When I add a chart to show the progress through time, the chart shows ...
1
vote
0answers
11 views

Pasting multiple formulas at once

I have a column of formulas (each created by concatenating several parts of a formula in cells to the left of it on each row), I want to be able to copy and paste these into a new sheet, whilst ...
0
votes
0answers
11 views

How to format cell if date is 7 days past the date listed in cell [duplicate]

I'm trying to keep track of regular due dates based on the last time the task was completed. Example: I have a task that needs to be completed about once every month. In column B I'm inputting the ...
0
votes
0answers
14 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 ...
1
vote
1answer
15 views

Combining columns horizontally with an arrayformula

I need to join columns with a formula (not a script) in Google Sheets in a different way than others I've found--here is my original data, supposing that the Avengers train by playing racquetball: ...
2
votes
1answer
69 views

Using Google Spreasheet's IMPORTXML Function to Download Selected Multiple Columns

I use Excel's XML mapping to download RSS feeds and select elements to display in column. I'm currently using Google Spreadsheet's IMPORTXML functions and trying to recreate my below Excel results. ...
1
vote
1answer
23 views

Hide row if cell contains specific text

I am trying to hide a row when a cell is filled with "x". I have tried using scripts but they don't work. So there are "A", "B" and "C" filled in column F. I want the script to hide rows where "A" ...
0
votes
1answer
17 views

Hide a row of cell when a specific cell is filled

I am trying to hide a row of cell when a specific cell is filled in on Google Sheets For example: On row 2 cell E2 is filled in with "1", I want to be able to hide the entire second row. Is there ...
0
votes
0answers
8 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 ...
2
votes
1answer
30 views

Unable to parse query string for function Query, when using ImportRange

This is the problem I'm getting: Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND The formula is of the form =query(importange("...", "Sheet!A:V"), "select D ...
3
votes
1answer
19 views

Using cell value to define sheet reference, e.g.: “=A1!B2”

I have data across different sheets in my Google Spreadsheet, called "data(Joe)", "data(John)", etc. From another spreadsheet I want to review that data in a structured way. I would like to be able to ...
2
votes
1answer
19 views

Lock two Google Sheet cells to each other

Is there any way to lock two Google Sheet cells to each other? What I need: I have data in cells A1 , B1 ; A2 , B2 , ... A1-B2 / A2-B2 must be adjacent. I need to sometimes copy A1-B1 to different ...
0
votes
2answers
29 views

How to sum cells in Google sheets that contain numbers and text

This has already been addressed in Excel but I was wondering how to do the same in Google Sheets. So suppose the B cell has this formula: ="frontend (days) total: "&sum(B2,B10,B14,B20) and the ...
0
votes
1answer
20 views

Sync multiple cells so that if any one of them is changed, the others change as well

I have 4 hard coded cells on 4 different sheets (within a google sheet file) that I'd like to keep synced. If any of those four cells have been changed, I'd like the other three cells to be updated to ...
3
votes
0answers
9 views

Populate column with editable range based on drop-down

So, here's my issue. I've got three sheets. One sheet has all of the classes for Mondays and Wednesdays, one sheet has all the classes for Tuesdays and Thursdays. The third sheet has a drop-down menu ...
2
votes
1answer
34 views

Import only those cells from a spreedsheet that have certain conditional formatting

I have created a Google form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created a conditional formatting which highlights the ...
1
vote
1answer
16 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
2
votes
1answer
24 views

How many spreadsheets are stored in my Google Drive?

A Google survey asked me: About how many spreadsheets are stored in your Google Drive? I ended up guessing, because I couldn't find a way to find the real number. In Google Drive interface, ...
0
votes
0answers
16 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
19 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
1answer
16 views

How to allow users to enter some data in Google Sheet without actually modifying the content?

I'd like to make a sort of calculator based on a grid, where the user checks different lines/columns and it will calculate some stuff based on what's checked. Perhaps I could do something in ...
1
vote
1answer
26 views

Run a formula multiple times in same sitting

I am trying to make a spreadsheet to keep track of the values of each upgrade in the game Reactor Idle. Each "level" increases the value by a certain percent. To predict the value after the next ...
2
votes
1answer
16 views

How to return only the first row containing the value you are searching for in a query?

=QUERY('F/O DEFVSREC'!$1:$1000, "select C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V where B='"&A35&"'label C'', D'', E'', F'', G'', H'', I'', J'', K'', L'', M'', N'', O'', P'', ...
1
vote
1answer
20 views

Inserting text from a cell into an importrange formula

I have a spreadsheet (Spreadsheet B) with a number of formulas which require data from another spreadsheet (Spreadsheet A). Many of the formulas in Spreadsheet B reference different sheets (on ...
0
votes
0answers
18 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.
2
votes
2answers
34 views

Filter multiple categories Spreadsheet

How do can I filter multiple words in a column? (for example i want to filter the words "golf" and "ski" to show up in my filter)
-1
votes
0answers
20 views

Sorting and Analysing Cell Data

I was wondering if it is possible to analyse data in a Google spreadsheet cell, and then sort that analysed data into different cells on a different sheet? Let's say the cell to be analysed contains ...
1
vote
1answer
26 views

How to refer to a cell's content from a query in Google Spreadsheets? [duplicate]

=QUERY('F/O OFF'!1:1000, "select H, J where B='CIN'label H'', J''") Right now this formula works fine, but i have to change the "where B=" for each row in the sheet. I want to get it so where B= ...
3
votes
2answers
77 views

Sortable Version/Requirement Numbering in Google Sheets

We use a number system like software versioning or IP addresses for business requirements, using decimal points to separate significant number sets. Spreadsheets don't handle this well because when ...
0
votes
1answer
29 views

Create Google chart from dynamic number of sheets

Is there a way to create a chart based on an ever-growing folder of sheets? For instance, if I want to graph the running average of some value always found in cell A1 across all sheets within a ...
2
votes
1answer
28 views

Transform a string according to a table of replacements

I need to create a QR code out of a few pieces of user-entered information, we will call them a b and c. I am doing this using a google sheet document and embedding this formula into a cell: ...
1
vote
0answers
13 views

How to use dot as splitter in currency format with Russian locale

I want to write currency in the format: ₽ 3 812.23 But if I select Russia as region in the table settings and format the string ₽ 0.00 result formatted number like ₽ 3 812,23 with a comma, ...
2
votes
1answer
27 views

Using regex in Google Sheets data validation

I'm trying to use a regex in the Google Sheets data validation in order to ban the input of special characters, so basically my allowed set should be [a-zA-Z0-9,./()]. I'm using the custom formula ...
3
votes
0answers
23 views

How can we retain authorship when we copy/paste a comment?

We have comments in a Google Spreadsheet that were not originally written by us. The cells the comments are written in already have "Conditional format rules" applied to them (e.g., cell H2). We ...
0
votes
0answers
12 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 ...
1
vote
1answer
15 views

Fill zeros for the dates when no data was recorded

I have a table with dates (in increasing order) and corresponding values. Some dates are missing, like 3/27 below. I'd like to insert them in Date column, and have 0 entered in the Value column for ...
0
votes
1answer
32 views

Google apps script to check availability

I'm using google form+calendar to create a reservation system for my makers lab. The user fills out the form and an event is created on the calendar so the TA knows when to goto the lab to help the ...
-1
votes
0answers
19 views

A single script that will Show/Hide Columns & Rows

How do I combine the below scripts so that either one will run depending on whether they are already showing or hidden? I'm thinking maybe an IF THEN statement? I'm looking for the script to run with ...
1
vote
0answers
23 views

Replacing last edited response with the old one in another tab [duplicate]

You can ignore column D, E, F and G cause those are just alphabetically ordered. So basically I want to draw the names of the responses on the responsesheet to this tab (see screenshot), which is what ...
-1
votes
0answers
27 views

SUMIF formula in Google Sheets

I am having trouble with a formula and maybe you can help me. I have created a Google Form where I am capturing when and how much my baby eats, among other things. I have a Sheets responses file ...
1
vote
2answers
28 views

How can I see Google spreadsheets in Myanmar font?

I want to know whether it is possible to see Google spreadsheet in Myanmar font. Because in my Ubuntu operating system I am not able to see the spreadsheet text in Myanmar font which show only boxes. ...
1
vote
1answer
20 views

Script to delete a dynamic range of rows

I'm looking for a script that allows me to delete a dynamic range of rows. Basically I have a script that adds rows to the bottom of a list but I want another script that will delete all rows in the ...
0
votes
1answer
19 views

Google Sheets sharing setting, “Specific people can access” but can't see each other

For Google sheets sharing setting, I have it on "Specific people can access", but the people can see who has access to that sheet. Is there anyway to make the setting so that the specific people can't ...
0
votes
1answer
38 views

Copy a row and add to the bottom of a list

I'm looking for script that will allow me to copy a specific row and paste it to the bottom of a list. The bottom of the list will not be the last row on the sheet. Using VBA I would have used an ...
2
votes
1answer
23 views

Reverse lookup from Google spreadsheet key

I can't figure out where the data in an IMPORTRANGE function is coming from. How can I use the spreadsheet key to find the the original spreadsheet IMPORTRANGE is pulling from?
1
vote
1answer
23 views

Reference one of my own spreadsheets, within another, by its name

I would like to reference a spreadsheet that is within my own Google Docs, owned by me. The catch is, the spreadsheet changes. It will be a different spreadsheet ever day, with the date as it's ...
0
votes
1answer
35 views

Using Google URL Shortener API in Google Sheets for bulk URL shortening

Recently come across similar issue to this question, where I want to add use the Google URL shortener API in Google Sheets for bulk URL shortening. However, I keep running into this error: Rate ...