Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-spreadsheets]

Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

0
votes
0answers
5 views

Can you auto update the range for a filter in Google Sheets [migrated]

I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows. The problem is, this sheet has new rows automatically added to it several ...
0
votes
0answers
3 views

Google Data Studio only imports old Google Fit data [migrated]

I have connected Google Fit to Google Data Studio to visualize my GF data, but last 2 weeks is not in Data Studio, only in my Google Fit app in my mobile. Can it be fixed, so I get current data in ...
-1
votes
0answers
29 views

How can I change the Google Docs (Sheets, Slides) user interface design? [migrated]

I have several Google accounts. I noticed that the user interface of G Suite Apps in my new account is different from the one in my old account. Could you please tell whether I can choose it and how ...
0
votes
0answers
143 views

Is there a way to remove specific rows which contain specific string “X”

I have a data-set in one column and I want to delete specific rows which contain specific text, lets say "Substitution:" Is there a way to do this task all at once?
0
votes
0answers
9 views

GOOGLE SHEETS : Defining Value to Numbers and Text and then Adding them [migrated]

I am comparing apartments and I have columns for features like bedroom, full bath, half bath, rent, pet friendly, balcony, laundry, utilities, parking, and bus access. Some of these have numbers like ...
0
votes
0answers
18 views

Google Sheets - Have row automatically move to another sheet upon specific selection in Drop down menu [on hold]

I am looking to have Google Sheets keep track of my companies jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" ...
0
votes
2answers
60 views

Advanced F&R Regex - Sheets / Excel - If “X” is in cell A1 and add “Y” to cell B1

I am looking for a formula or regex that I can use to find a value in a string in one cell and if found add another string to the adjacent cell in another column. For example, I have a list of ...
-1
votes
0answers
14 views

Show all pages in google spreadsheet [closed]

I have many pages in my Google spreadsheet document. I can reach them by using scrollbar. But I would like to see all them at once. How to achieve that? Is it possible somehow get two or even more ...
0
votes
0answers
11 views

How can I use google apps script when advanced protection is on? [on hold]

A while ago I created a Google script embedded in a Google sheet in my regular personal Google account. This script modifies the menu (.addMenu() method) and gets and sets data from the spreadsheet (...
-1
votes
0answers
16 views

Hide specific columns based on cell value [on hold]

I've searched for a solution to my situation, but have only come up with bits and pieces of what I'm looking for. As the title states, I'm wanting to hide specific columns based on the value of a ...
0
votes
0answers
18 views

Google Sheets Auto Fill a cell when dates are entered in 3 other cells [migrated]

I'm trying to create a way to keep track of our jobs by creating a google spreadsheet. We can only order our final product when the digital and hard copy proof is approved and we have an order from ...
0
votes
0answers
5 views

Google sheets create sequential dates with each date repeated multiple times [migrated]

For every day of the year I need the day repeated in 10 rows. How can I accomplish this efficiently? e.g. 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/...
0
votes
0answers
19 views

How to connect Google spreadsheets with odoo 11

I am using odoo11 on my laptop and i want to connect my spreadsheet in google to my database odoo How can i configure it ? I need urgently help please.
0
votes
0answers
7 views

Google Sheets ImportHTML parse error [migrated]

I want to use the importHTML function of Google Spreadsheets. There is this example by Google itself: =IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) Unfortunately (like ...
0
votes
0answers
6 views

Images from GDrive into GSheets

I am trying to build a seating chart for teachers that will accept the student name (from a drop down box) match it with their student number and then insert the image file (stored in GDrive under "...
0
votes
0answers
4 views

How can you find or highlight all cells having validation in Google Sheets? [migrated]

My spreadsheet has several cells that have had validation applied to them, but it would be nice to recheck them or switch the validation to a complimentary cell. After searching on Google and looking ...
0
votes
0answers
8 views

How to calculate a monetary value for a given duration in minutes and seconds? [migrated]

I have a monetary value for 1 minute like 0,10 € (10 euro cents per minute) In Google Sheets I have a column to enter a length of time in minutes and seconds like "xx,xx", ex. 1,30 The calculation ...
0
votes
0answers
11 views

How do I copy dropdown lists from Excel to Google Sheets?

I have an Excel sheet with dropdowns. Each dropdown has anywhere from 40 to 1000 values. Right now, to copy from those values, I need to individually select those values and copy it to a dropdown in ...
1
vote
0answers
8 views

google sheets - plot of dates on timeline [migrated]

I have a column of dates, eg. 2017-01-20 2017-01-25 2017-01-27 2017-01-30 2017-02-03 ... 2018-12-20 I would like to create a plot where the x-axis is a contiguous range of dates from start to end (...
0
votes
0answers
6 views

How can I modify hotkeys for google sheets (or perhaps any site)?

I'm looking for a means to disable and/or remap a few hotkeys from Google sheets. In particular, Meta+Enter for new lines has got me messed up bad. I never knew how widely used this key combo is, ...
1
vote
0answers
61 views

How to work Google Sheets?

I am working in Google sheets which is the same as the excel program. How do you make it so that when one cell is changed in a column all of the cells in that column are also changed so that they all ...
0
votes
0answers
23 views

How to open MS Office files like XLSX, DOCX with google drive by double click? [duplicate]

I've found this question, but the answer given there is outdated since google seems to have abandoned the extension mentioned in it (the extension looks like an old version of google docs, misses most ...
0
votes
0answers
49 views

Figuring Portion of a number based on two percentages — Math/Logic/Statistics Issue using Spreadsheet

Looking for Logic: I can't figure it out. 16% Power of 49,000 Troops with a bonus of 26.75% power or 126.75% strength bonus. Each column of the table has it's own Bonus % and I would like to find ...
0
votes
0answers
26 views

Extracting multiple emails in single cell on Sheets

There are other posts for this question (how to extract multiple email addresses from one cell), but I haven't found the solution for Google Sheets...at least not a solution I can understand and ...
0
votes
0answers
6 views

How can I create a list of references that update properly when cells are deleted from the base list?

I have two sheets - we'll say Fruits and Products. On Fruits, I have a list of fruits: In Products I have a list of cells that contain references to this list of fruits (actual formulae are shown in ...
0
votes
0answers
6 views

Calculated pivot table field, where one of the fields matches certain value?

is it possible to create a Calculated field in a Pivot table (either Excel or Google sheets, I feel comfortable with both), but only where values of Field 1 match certain criteria? For example: Data ...
0
votes
2answers
32 views

How to automatically calculate formulas from new form submission data?

I am trying to count the number of dates submitted from an entry provided via form. I have figured out the formulas to do that. The problem is that every time a new form entry gets submitted a new row ...
0
votes
1answer
18 views

MINUS on column and corresponding row

I'm looking for a simple solution to getting the current row for a formula. Column C is Gross Pay Column D is Net Pay I want Column E to be Taxes Paid by subtracting D from C. All the answers I've ...
0
votes
1answer
323 views

How to create a Supply & Demand style chart

Here's an example of a basic Supply and Demand Graph: The Vertical Axis is always Price The Horizontal Axis is always Quantity There should be two lines, one for the supply curve and one for the ...
0
votes
1answer
64 views

EPS for a market in Google Sheets

In Google Sheets, I can use the GOOGLEFINANCE function to get a number of stock data points including: price volume eps I have used the GOOGLEFINANCE function on market data points for the Dow (...
0
votes
2answers
32 views

Microsoft Word/Excel equivalent to the “Search the Menus” functionality of Google Docs/Sheets

In Google Docs/Sheets, I can hit Alt-/ (M-/ for Emacs users :) ) to bring up a menu that allows me to quickly search all the menus for a particular function and to select that function with [Enter] (e....
1
vote
0answers
28 views

Have Multiple Selected Elements in a Cell Dropdown

I would like to select items from a pre-created list of possibilities. This is why I use a data-validation dropdown. But I would like to select more than one dropdown element. How can I implement in ...
0
votes
1answer
41 views

How do I add checkboxes inside a dropdown in Excel or Google Sheets?

I would like to have the data validation that is possible with having a dropdown but I would like to have more than one selection. Is is possible for a cell dropdown to have checkboxes beside the ...
1
vote
1answer
63 views

How to auto-format an Excel cell based on another cell in another column?

I'm cataloging a games items in a Google Sheet. I need to take the value from one column, format it (with underscores instead of spaces, and a .png at the end), and save it to another column. For ...
0
votes
0answers
16 views

How to Highlight Today from List of Dates in Google Sheet?

I have dates listed in Google sheet as shown below: I want to have a way by which it will highlight the current date everytime I would open the sheet. How do I do that?
0
votes
1answer
56 views

How to vlookup/hlookup in microsoft excel?

I have a relatively simple formula that I can not figure out. I need to use B1 and B6 to return a value in B7. B1 needs to match the value in row 12. Then using only that column of the matched value, ...
0
votes
0answers
51 views

Count number of rows based on multiple criteria

I have a sheet used to calculate work-time for contractors and catch errors. Each row is a time-entry, with columns used to indicate the employee name, campus visited, date, time-in, and time-out. I'...
1
vote
1answer
112 views

ImportHtml/IMPORTXML in Excel/Sheets - load next index after content of variable size

I'm using functions such as ImportHtml to import tabular data into Google Sheets. Each table has the same headers but contains an unknown number of rows. I need each table from a list of URLs to ...
0
votes
2answers
83 views

Converting lots of Excel files to Word

I have around 30 Excel spreadsheets, each with 20+ worksheets. Each of these worksheets follows the same basic format, though there are slight differences. I also have a Google doc with sections ...
0
votes
0answers
22 views

How to display rows based on column criteria in Google Sheets on a separate sheet?

I have a Google Sheet I'm working on with around 98 rows that will constantly be changing. One column is an ID number that assigns a positional rank and populates other sections of the sheet. What I'd ...
0
votes
1answer
60 views

spreadsheet formula for returning parts of filtered cells in column

I use Libreoffice. (If Excel or GoogleSpreadsheets would be the only way to get a solution, I would be willing to switch. But the preferred platform is LibreOffice, I'm looking for a solution on this ...
0
votes
1answer
22 views

Drag Down Formula whilst retaining some values but change another [closed]

I'm looking for assistance with a problem i'm having when using Excel. The best way to explain the problem i'm encountering is that i'm using the auto-fill drag down to copy and paste essentially a ...
0
votes
2answers
114 views

How exactly do I make multiple columns into one row to sort?

Currently trying to sort data into alphabetical order, however, I am running into a problem. Every time I try to sort it the product number doesn't match up with the product. I have been going on ...
0
votes
1answer
47 views

Copying from a table row to spreadsheet with formula

I have this sample data from my HTML table row. Tester sample@gmail.com 2018-07-19 1000 1200 new And I am copying this data to google spreadsheet with a formula ...
1
vote
1answer
32 views

How to count all the items in 2 columns depending on comparison?

I have two columns with data and I'd like to count all the rows where the value in the first column are greater than the values in the second column. The best I could find was using cell references, ...
0
votes
1answer
30 views

How to sort based on excel or sheets column data

I have a form that submits to a google sheet with the following columns: Entry Date, First Name, Last Name, Address, Phone, Email, Member Type, Vote Date, Result (The 'result' column has three ...
1
vote
1answer
107 views

Conditional Formatting using average function in Google Sheets/Excel

I am trying to figure out how to conditionally format a particular cell depending on the average value of a number of other cells. So I've tried a variety of solutions all either ERROR-ing or not ...
1
vote
1answer
14 views

How to add a cell range, then divide the sum by 1 cell. [closed]

How do I add cell range of BC3:BG3, then divide by cell BC3. Then I need to turn that answer into a percentage.
0
votes
0answers
13 views

Increase visibility of reference errors when working in Google Sheet

I am pruning and splitting up an important Google Sheet into multiple sheets. As I do this, I may break certain formulas and references. Currently, when a formula is broken a cell value turns into "#...
1
vote
1answer
57 views

How to split Google Sheet across tabs whilst retaining references

I have a Google Sheet which contains two 'tables' of information one holding Common data on the left, and one holding specific data on the right. (In my real life scenario have about 10 other tables ...