Skip to main content

Google Sheets: Notes

"Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time." — TechTarget

>>> To create a new worksheet, access https://sheets.google.com/new

>>> Calculate number of days, months, or years between two dates

=DATEDIF(start_date; end_date; unit)

DATE DIFFERENCE: Calculates the number of days, months, or years between two dates.
start_date: from date
end_date: to date
unit: DAY, MONTH, YEAR...

>>> Get value from "Price" sheet, 'N2' cell.

var cellValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Price").getRange('N2').getValue();
// Logger.log(cellValue);

>>> GOOGLEFINANCE function: https://spreadsheetpoint.com/googlefinance-function-guide/

>>> IMPORTHTML: Imports data from a table or list within an HTML page.

>>> CANNOT DIRECTLY insert special characters in Google Sheets, but CAN copy & paste special characters.

Popular posts from this blog

Printer Support

JumpCloud: Notes

https://jumpcloud.com/

Linux command: lastlog

lastlog command reports the most recent login of all users or of a given user. NAME lastlog - reports the most recent login of all users or of a given user SYNOPSIS lastlog [options] DESCRIPTION lastlog formats and prints the contents of the last login log /var/log/lastlog file. The login-name, port, and last login time will be printed. The default (no flags) causes lastlog entries to be printed, sorted by their order in /etc/passwd. OPTIONS The options which apply to the lastlog command are: -b, --before DAYS Print only lastlog records older than DAYS. -h, --help Display help message and exit. -R, --root CHROOT_DIR Apply changes in the CHROOT_DIR directory and use the configuration files from the CHROOT_DIR directory. -t, --time DAYS Print the lastlog records more recent than DAYS. -u, --user LOGIN|RANGE Print the ...