Combine multiple Google sheets that can keep updating

Okay, so I think, no one seems to have exactly the same problem as I do…

I have an app writing automatically my health data into a google sheet.
It does so in three different sheets inside the one file.
Column A is always the date.
Now, I’d would like to have a master sheet, that combines this data.

Like this:
Sheet 1: A1:20/07/21, B1: value1
A2:19/07/21, B2: value2
Sheet 2: A1:20/07/21, B1: value3
A2:18/07/21, B2: value4

Result: A1:20/07/21, B1: value1, C1:value3
A2:19/07/21, B2: value2
A2:18/07/21, C3: value4

So in essence, I’d like to sort by date and combine the values from the two sheets into one line so there is one date per day.
Is that even possible?

I’ve tried different queries and IMPORTRANGEs, but to no avail.
I am a sheets-newbie, though…

Any help appreciated!

How can I show historical performance for stocks in Google Sheets?

I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include columns showing historical performance (1-month, 3-month, etc.) for all the stocks included in the sheet. I thought I had it figured out after finding this Reddit thread, but it’s not working.

Starting with 1-month performance, here’s what I’ve entered in the relevant cell (cell A2 contains a ticker symbol):

=GOOGLEFINANCE(A2)/GOOGLEFINANCE(A2,”close”,TODAY()-30)

That gives an error message that says,

Function DIVIDE parameter 2 expects number values. But ‘Date’ is a text and cannot be coerced to a number.

I tried removing “”close”,” which changes the input to

=GOOGLEFINANCE(A2)/GOOGLEFINANCE(A2,TODAY()-30)

but I still get an error. This time, it says,

Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified.

What am I doing wrong? Any help is appreciated!

How can I include two formulas in a single cell in Google Sheets?

I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include the daily price and percentage change in a single column. I found a helpful Docs Editors thread, and I was able to get it working the way it’s formatted in the answer from that thread.

What I’m starting with is the following input (A2 contains a ticker symbol):

=GOOGLEFINANCE(A2,”change”)&” | “&GOOGLEFINANCE(A2,”changepct”)

That displays this (using random numbers):

1.25 | 3.15

That technically works. However, I’d like the data to display in a different way. This is what I’d prefer:

+$1.25 (+3.15%)

The parentheses are the most important part, but I’d also like to show the dollar sign, percent symbol, and plus symbol if possible (the minus symbol will always show for negative values, but I want to also always see the plus symbol for positive values).

I’ve changed the input to the following:

=GOOGLEFINANCE(A2,”change”)&” (“&GOOGLEFINANCE(A2, “changepct”)”)”

That gives me an error that says, “Formula parse error.” Changing it to

=GOOGLEFINANCE(A2,”change”)&” (“&GOOGLEFINANCE(A2, “changepct”)

gives a functioning result, but it’s of course missing the closing parenthesis. The cell displays as

1.25 (3.15

What am I doing wrong? Any help is appreciated!

referencing a column in a Google sheets array literal

Is there a way to refer to columns in a literal array like so:

=FILTER({lengthy_arrayformula_1, lengthy_arrayformula_2}, condition referencing column 2 of the array literal in previous argument)

or

=INDEX({lengthy_arrayformula_1, lengthy_arrayformula_2}, row, 2nd col of the literal array)

without creating ‘buffer columns’ that hold intermediate results.

import – Dealing with data from multiple individual spreadsheets. Should data be merged OR are there better ways to deal with multiple sheets?

I have transactional data (spreadsheets) from different time periods and would like to know if there are better ways to import the data to a mastersheet, than to merge all the spreadsheets into one? If I merge the data, I will have to append items to this master document in the future which could be an option, but am wondering if there are methods to consider?

Kind regards

Google Sheets: Line Graph of alternating columns. 1st Column as label

Month Notes January Notes February
Net Worth $500 $600
Liabilities $50 $40
Credit Cards $10 $20
Credit Card 1 $5 $10
Credit Cards 2 $5 $10
Savings & Checking $400 $500
Investments $100 $200

I have a google spreadsheet I use for tracking monthly financials that looks something like this. I use a new tab or sheet per year.
I was looking to add a Dashboard to the first tab that would display an individual line for each row.

Essentially I want the row and column labels to be the same I have here but translate the numerical values into a line graph.

I have attempted to select all of the cells with the respective data manually. I have tried selecting the ranges – but with my notes columns and there are detailed rows underneath each of the rows displayed here i.e. credit cards have a row each for each card, etc. So the rows and columns in the sheet are not exactly contiguous. I’m pretty sure I’ll have to manually click each item. I have also tried selecting a row with the column intended become that row’s label and the numeric values in that row as the plotted lines – but that doesn’t seem to work very well either. Especially if I try to add more than one row. to display multiple lines.

google sheets – Send email when there is a change in column

I would like an automatic notification to be sent to several people when I entered ‘Yes’ in column C. I wish this would apply to Sheet1 only, not to the entire file.
I have this code

function myFunction () {

   var sh0 = SpreadsheetApp.getActiveSpreadsheet (). getSheetByName ("Sheet1");

   var editedCell = sh0.getActiveRange (). getColumnIndex ();

if (sh0 = "Sheet1" && editedCell == 3) {


var recipients = "xx@xx.com";
  var subject = "xxx";

  var body = "xxx"

    MailApp.sendEmail (recipients, subject, body)
  }
}

However, this works for the entire file, not just Sheet1. What is wrong?
I would like to additionally add information from the twin cell from column A to the content of the e-mail.

formulas – Google sheets – how can I use functions to resort my table in a way charts can read it well

I’m using app sheets to see what I do in a day. I select the task I am starting on the app and app sheets dumps the data into a table in google sheets.

I have made an example of what this looks like. Sheet1 is what it looks like At the moment and sheet2 is what I would like it to look like (or something else that will help charts read it).

https://docs.google.com/spreadsheets/d/1GF6cjlNMSTJov4G6ZMusXSWS-DMwnK4SgQqNs8d8uws/edit?usp=sharing

I have been pulling my hair out trying to do this so if you know how please tell me.

google sheets – Applying conditional formatting independently to each other

enter image description hereHere is an example file for where I want to apply conditional formatting independently of each other

First I have highlighted all males in the spreadsheet

Then if they are a senior I want the text of the entire row to be bold but I can’t seem to get it

The rows where the previous formatting has been applied do not have the second formatting applied

I can understand that if I make another rule where I check both conditions simultaneously I can get the desired result but I ultimately want to have several conditions so this method is not feasible

Any help with this would be appreciated

https://docs.google.com/spreadsheets/d/1cnpsPIZU5Vrz3ung0Dqmv67ECWk8ZaLF0bvtxN6FkGY/edit?usp=sharing

google sheets – Need help referencing data from another tab and inserting the result in a single cell

Enter this formula in sheet “Prepack Dashboard”, cell E2.

=ArrayFormula(IF(isblank($A2:$A),"",VLOOKUP(A2:A&B2:B,{'Inventory Minimums'!$A$2:$A&'Inventory Minimums'!$B$2:$B, 'Inventory Minimums'!C2:C},2,0)))

Breakdown
VLOOKUP looking up an array (the part in curly braces)

  • VLOOKUP(A2:A&B2:B,{'Inventory Minimums'!$A$2:$A&'Inventory Minimums'!$B$2:$B, 'Inventory Minimums'!C2:C},2,0)
  • this takes the combined value of the “Strain” and “Inventory Type” from columns A&B of “Prepack Dashboard”, and looks that up in the combined columns A & B of “Inventory Minimums”
  • when it finds the lookup value, it returns the value from Column C (which is the minimum quantity).

ARRAYFORMULA

  • This allows the formula to be automatically copied down for as many rows as there is data. Without this, VLOOKUP would have had to be copied manually. Even if ARRAYFORMULA was applied to the VLOOKUP, it would not automatically copy it down the column.

IF and ISBLANK

  • This is the “trick” that enables ARAYFORMULA to copy the VLOOKUP formula down the column.
  • This passes an array to ARRAYFORMULA which it can useuses to copy down the column.