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

Windows 10: Install SuSE Linux Enterprise - SLES

With Microsoft-Windows-Subsystem-Linux feature enabled, we can install Linux distributions on Windows 10.

Microsoft AI Shell: Notes

AI Shell

[MicrosoftVisualStudio]: Microsoft Visual Studio shortcut keys

Source:  http://visualstudioshortcuts.com/2015/ Analyze Navigate Backward Shift+Alt+3 Navigate Forward Shift+Alt+4 Architecture New Code Map Ctrl+\, Ctrl+O New UMLor Layer Diagram Ctrl+\, Ctrl+N Architecture Context Menus Add Node Ins Both Dependencies B Incoming Dependencies I Outgoing Dependencies O New Comment Ctrl+Shift+K Ctrl+E, C Remove Del Rename F2 Build Build Solution Ctrl+Shift+B Cancel Ctrl+Break Compile Ctrl+F7 Run Code Analysison Solution Alt+F11 Class Diagram Collapse Num - Expand Num + Class View Context Menus Properties Alt+Enter Misc Commit All Edits Shift+Alt+U Move Left Edgetotheleft Ctrl+Shift+, Move Left Edgetotheright Ctrl+Shift+. Move Right Edgetotheleft Ctrl+Shift+Alt+, Move Right Edgetotheright Ctrl+Shift+Alt+. TSql Editor Clone Query Ctrl+Alt+N TSql Editor Database Combo Shift+Alt+PgDn View File In Script Panel Shift+Alt+PgDn Debug Apply Code Changes Alt+F10 Attachto Process C...