Questions tagged [google-sheets]

For questions about the Google's web application to create and edit spreadsheets on a web browser. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question, this will greatly increase the chances to get a satisfactory answer.

Filter by
Sorted by
Tagged with
1
vote
1answer
12 views

How to display list of items that is in other sheet but not in the other? [closed]

As the title says, I need a column to show what is not on a range(BASIS) that is in the other sheet(BASIS) : I've been searching for hours now but only found the opposite results.
0
votes
1answer
14 views

Can I populate Google Sheets cells adjacent to a target cell?

I have a maintenance tracker in Google Sheets for lighting fixtures. One column is a type of fixture "B", the column adjacent is the problem "C". I'd like to find specific fixtures by name and copy ...
0
votes
1answer
18 views

Conditional formatting with multiple names in list

Col A2:C15 contain a list of names. I need to enter those names in various combinations into one of 15 other cells on formatted like: H3 = John, Steve, Bob, Dan Is there a way to use conditional ...
1
vote
1answer
11 views

How to create new cell from keyword of another cell?

I have a column that has job listings with extra info, so I only want to grab the job position and place it into a new cell. A1: Seeking Assistant to the marketing division... B1: Assistant (...
1
vote
1answer
56 views

Searching for mails received on Saturdays in Gmail

I need to get the list of emails sent on a day of the week by a service. Is that possible to find in Gmail? Such as 'only Saturday' emails or 'Sunday & Wednesday' emails? Or any email client ...
0
votes
1answer
16 views

Google Sheets on PC Copy/paste using “Paste Values” (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS

When I copy numbers using either "Edit/Copy" or "Crtl+C" in Google Sheets on PC and then use "Edit/Paste/Special/Paste Values" or (Crtl+shift+V), the numbers are indeed pasted. They appear normal and ...
1
vote
1answer
25 views

How to extract data from a table dynamically?

I have the following table And I would like a formula that would produce the following result I would like to iterate through the table going from left to right top to bottom and if there is a ...
1
vote
1answer
27 views

How to search value in another column?

Using Google Sheets, I am trying to two compare two columns on Google Sheets, like the one below: Basically, I want to compare column A and B, basically, if a cell in column A is inside a cell in ...
1
vote
1answer
31 views

How to Iterate between colunns and rows?

I am running the following forumula: =IF(INDEX(C$2:$2, 1, ROW(1:1)),CONCATENATE(B$2,"-",INDEX(C$1:$1, 1, ROW(1:1)))) On the following table Basically, If a value is present in column C2, I am ...
-1
votes
1answer
17 views

Google Sheets images

When I insert an image in a cell in Google Sheets from my camera how is that image stored in the cell? I know it creates an image in my phone in a folder called images, but if I want to link that ...
0
votes
1answer
18 views

Which event can I use to detect remote form submission into sheet?

I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row. Which event can detect that that information was ...
0
votes
1answer
12 views

Conditional formatting on whether something is a formula in Google Sheets?

Is there a way, in Google Sheets, to have conditional formatting of some sort, to change the background color of a cell based on whether the cell contains a formula or a plain value?
1
vote
1answer
14 views

Is there a specific limit to how long a formula can be and what is considered to be the limit?

I am currently taking a course that involves Google Spreadsheets and was wondering if there was a specific limit to how long a formula can be in one cell and how many functions are the max. I am ...
1
vote
1answer
22 views

Delete Google Sheet rows matching multiple criteria with custom formula

I have a Google sheet where I am trying to remove multiple rows matching any one of a vector of values using (Filter by condition -> Custom formula). For this example, let's say I want to remove ...
0
votes
2answers
67 views

ImportXML not loading due to number of requests

I am working on this sheet and it has a lot of ImportXML requests between columns N-Q. And because of the high number of requests, it seems like the ImportXML function is not working properly (it ...
1
vote
1answer
22 views

Conditonal Formatting if cell A is within a range of numbers to make cell B a different color

I am looking to create a conditional format that if a cell "A" is within a range of two numbers that cell "B" will then change color in Google Sheets. Please help.
0
votes
1answer
34 views

Generate “cards” with info in Google Sheets

I have a sheet for an event and I need to generate identification cards like in the image for the pieces on the contest, around 1000 pieces, so no way to manually do it. I did a similar thing years ...
1
vote
1answer
18 views

How can I return a string instead of a number when the number is 0

I have a formula that returns average lbs, waist and body fat % for the weeks I've been dieting. The problem is I didn't measure body fat % until a while after I started so some averages are 0. I'd ...
0
votes
0answers
29 views

Sort data without blanks or zeros

I have a sheet (Sheet7), that imports data from another sheet (Sheet5) when a value is selected. The data is updated upon submission. The problem I have is if the cell value is not selected I get ...
0
votes
1answer
19 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
1
vote
1answer
18 views

How to format clipboard text as data row in Google Sheets?

I've noticed copying text with a link preserves the link when pasted in Google Sheets. I've also tried copying an inline list from an HTML page and noticed it gets copied as two rows. Is it possible ...
1
vote
1answer
25 views

How can I change the formula of one cell based on the value in a different cell?

COLUMN D: Dropdown list of values COLUMN E: IF function returning different values depending on COLUMN D contents I have the functionality described above working properly. My problem is that I want ...
0
votes
0answers
2 views

Hyperlink Another sheet with exact lookup value

Kindly solve this issue I am able to use this formula in excel but I am not able to use this formula in google spreadsheet =HYPERLINK("#Another sheet name!"&CELL("address", INDEX($B$1:$B$547,...
1
vote
1answer
16 views

How to get an array for a range per a column in Google Sheets?

I'm looking for creating a similar formula: =UNIQUE({A:A;B:B;C:C}) So, I need such kind of a range {A2:A;B2:B;C2:C;...} (each column separated with the semicolon) for several hundred columns. Seem, ...
2
votes
1answer
44 views

Force Google Docs/Sheets to ALWAYS paste values only (merge formatting)

I do a LOT of copying from external sources and pasting into Google Docs/Sheets. Is this at all possible? I know the keyboard shortcut but can't seem to get used to it. Would save me so much time!
2
votes
2answers
90 views

Google Sheets Split row in multiple rows

I'm doing a spreadsheet for an event and I need to split a row into multiple rows. It's getting data from a form. I need a script that can arrange the data like in the blue rectangle.
1
vote
2answers
26 views

Google Sheets IF and 2 x ANDS

I have three columns in my google sheet. COL A - will hold an invoice number (text field) or be empty COL B - will display the word EXEPNSE COL C - this will be my formula column I need to detect if ...
1
vote
1answer
28 views

Entire Column green if all cells in it are empty

I would like all columns that only contain empty cells to light up green. In the below picture these should be: C3:C8, D3:D8, E3:E8, L3:L8 What would be the correct custom formula for this? Bonus ...
1
vote
1answer
20 views

How can I change the font of selected text within a cell in Google Sheets using keyboard shortcuts?

I am attempting to change the font of selected text within a cell in Google Sheets using a keyboard shortcut. I have attempted the steps meant for google docs here: How can I change the font in ...
0
votes
1answer
18 views

Import and SUM chosen (from drop-down) column to Sheet1 from Sheet2

What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list? Here's the document.
1
vote
2answers
38 views

sheet name from cell (formatting issue)

I have been tasked with creating reservation sheets for a restaurant. The sheets are for internal use only so the only people with access to these sheets are the staff in the reception, reservations ...
1
vote
1answer
37 views

Adding date picker to Google Sheets cells while data validation is customized

I have a column with customized data validation (custom formula) that accepts only dates, provided that a few other conditions are met. How can I add a date picker to the cells of this column? ...
1
vote
1answer
15 views

Only use last X values in a plot in Google Sheets

I'm using a Raspberry Pi to automatically measure the temperature and humidity in my room and append that data to a Google sheet every few minutes. I use several methods to display the current data (...
0
votes
1answer
15 views

Auto hide row based on cell text (formula based)

My plan is to hide an entire row if a specific cell in the row showed specific value. I already found the script and the script work amazing. But the problem now, since the script use onEdit function, ...
1
vote
0answers
15 views

Creating new Google Sheets automatically [closed]

I have a Google Sheet with formulas. A new row is added to this Google Sheet when a user submits a form (this row has the answer/data of that user). Then, the Google Sheet makes calculations on this ...
1
vote
1answer
11 views

Google Sheets time sorting chart

I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I ...
0
votes
0answers
21 views

Google Sheets. Adding timestamps for multiple sheets in a workbook

Here is a copy of my current workbook https://docs.google.com/spreadsheets/d/1S7V4Gkgr_1DiP5sMQ3EWYffvRi4S0b-C7G0O6MGejY8/edit#gid=442994829 Right now i am using a script that performs a timestamp ...
0
votes
3answers
31 views

Else statement is executing when TRUE

I am completely new to coding. I am a teacher and trying to design a lesson planner tool using Google Sheets Scripts. The idea is to have a template sheet for the lesson that will copy into a new tab. ...
0
votes
0answers
14 views

VLOOKUP formula combined with IF

I have a function which funnels details of order onto another tab (Order Well). On my master order tab, if the column for the order qty is blank, I want it to look at the Order well tab, like a ...
2
votes
1answer
15 views

Dynamically creating column names based on data in another tab

I have a Google sheet that logs all submissions on my website of various contact forms. I need to know how many times each contact form has been submitted, and in which week they were submitted. The ...
1
vote
1answer
16 views

Pull image or skip to next cell if empty

I am currently using Google Sheets to make a list of videos and thumbnails. I have various sheets titled: Frying, Stewing, Baking, etc. Within each sheet, there are only two columns which include a ...
0
votes
1answer
15 views

Pull data when cell value is selected

I am Trying to pull data from part of a sheet to another part depending on if dirt level 22 value is filled in. Please see attached Picture, basically, the bottom section pulls data from rows above ...
0
votes
0answers
13 views

Automatically send email with cell value selection

I have 4 sheets, all are the same layout but follow on from the 1st but when sheet 1 reaches row 22, the data then stars filling out sheet 2 and so on. What I need is for these sheets to be emailed on ...
0
votes
0answers
49 views

How do I send an email on a Google Sheet when certain cells change using the Apps Script?

I created a script to send email on Google Sheet with the following conditions: When the Assign Email column is filled in and the Status column changes to In Progress, then the notification will ...
1
vote
2answers
31 views

subscrpt/superscript in Google Sheets

How to subscript or superscript in Google Sheets? The Doc's shortcut (ctrl+, / ctrl+.) is not working there.
1
vote
1answer
19 views

Conversion from LibreOffice to Google Sheets

I use LibreOffice to create xlsx files. There are some formulas to test conditions. Everything is ok under LibreOffice but when I open the file with Google Sheets formulas give the wrong result. e.g....
0
votes
1answer
10 views

How to check separate sheet cell for any data, and return a Y?

I'm using several Google sheets to capture product data and optimize it. One sheet will feed data into the next, and then again into another sheet, using this formula: =IMPORTRANGE("https://url-to-...
1
vote
1answer
11 views

Output data if value is less than today's date

I have a spreadsheet. I want to create a formula that checks the date of one cell and if the value is lower than today's date, it to output the word required into another cell. How would I do this?
1
vote
1answer
48 views

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows

I've been trying to get this array formula to work, but I get an error. It's just a vlookup array to display multiple columns. It works fine without the {""; bit, but I want it to drop down one row. =...
0
votes
1answer
20 views

Auto-jump on today's date upon upening the spreadsheet [duplicate]

I use a spreadsheet with a date in a row per column. I would like to have the sheet open on the current date when opening. How can I make this?