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

Office 365: Alert Policies - Creation of forwarding/redirect rule

The default Creation of forwarding/redirect rule alert policy will be triggered when end-users create rule to forward or redirect mail

Linux command: telnet

telnet stands for "Teletype Network".

Powershell: Get-ChildItem

List, search/find files and directories with Get-ChildItem cmdlet.