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
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
0answers
5 views

Get eToro Balance into Google Sheets [closed]

Has anyone managed to get an automated solution to extract the portfolio value of your own user account into Google Spreadsheets automatically? I have a sheet where I track my finances and my ...
0
votes
0answers
22 views

Conditional formatting if entry is final entry of the day [migrated]

I have a Google Sheet in which I keep track of transactions, kinda like this: | Date | Funds | Running total | |---------|---------|---------------| | 5/23/18 | 10.00 | 10.00 | | 5/23/...
0
votes
2answers
22 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
0answers
6 views

Google Sheets - count unique tags [migrated]

I’m trying to list and count all tags in my table. For some reason, anything after comma, is getting a white space before the word. So if the tag is found on the beginning of a record, it is seen as ...
0
votes
0answers
14 views

Temporarily disable autosave in google sheets [migrated]

I use autohotkey scripts for a lot of things in google sheets. It's basically scripted, automated keyboard input. A script may look something like this: Loop, 4 { Loop, 7 { Loop, %...
0
votes
1answer
16 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
0answers
5 views

Is it possible to calculate in the background of a data validation cell? [migrated]

Is it possible to calculate in the background of a data validation cell? I am creating a quite comprehensive spreadsheet that shall help me calculate dice pools in an RPG, but to not trouble you with ...
0
votes
0answers
3 views

How do I conditionally format text color to match across sheets in Google Sheets? [migrated]

My problem is as follows: I am creating a schedule for a sports photography company that uses several photographers to shoot team photos at tournaments. There are 2 sheets in this instance; the ...
0
votes
0answers
10 views

Google Sheets / Excel 2016 [migrated]

I have an issue with duplicate sorting values for a formula in Google Sheets. I'm using two tables to order 10 scores (see pic). The values in Column D are dragged from another sheet. The values in ...
0
votes
1answer
55 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 ...
-1
votes
0answers
25 views

Is there any way to sync two spreadsheet with each other?

Is there any way to two-way sync two spreadsheets with each other? I mean, if someone will edit in Spreadsheet 1 then that thing should appear in Spreadsheet 2. It should work for all the cells and ...
0
votes
0answers
8 views

Google Sheets Combining multiple IF statements into one formula (as an Array) [migrated]

Hope someone can help, got the formula below but I want to modify it so that the first IF formula, IF(F3:F="Delay","Delay", returns a “Delay” if it finds a match (not if it finds "Delay") and if it ...
-4
votes
0answers
26 views

Comparing two column in two separate excel

In Sheet1 Column a1/b1 has 1111 /24.09.2015 A2/b2 has 1111/26.10.2000 A3/b3 has 1111/ 30.10.1994 In sheet 2 column a1/ b1 has 1111/...
0
votes
1answer
31 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 (...

15 30 50 per page