Notes

Ujnotes — CC0 1.0

Working notes on Notes: Reference data from sheet, Reference data from workbook, =importrange(spreadsheet-key, range), and =text(A1,”0000”).

Formula.

For fn.

Reference data from sheet

=<Sheet>!<Row><Column>

Reference data from workbook

=importrange("<key>", "[<sheet1>!]<<A1>[:C10]>")

=<SHEET>!<COLUMN><ROW>

=Left(Concatenate(Sheet1!A2, " ", Sheet1!B2, Sheet1!C2), 16).

=importrange(spreadsheet-key, range)

Quote enclose both params.

=getCurrentSheetName() after Installing script -.

“Tools > Script gallery.... Search for sheet name”.

=text(A1,”0000”)

min 4 digits with leading zeroes when needed