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

IIS: Delete cached files on server running IIS

Delete cached files on server running IIS When changing css, javascript files, check to delete if IIS still caches old files in the default folder C:\inetpub\temp\IIS Temporary Compressed Files\<sitename>\$^_gzip_D^\ Apply to: IIS 8.5

Linux command: du - disk usage

Where have all my storage gone? du summarize disk usage of the set of FILEs, recursively for directories.

ManageEngine ServiceDesk Plus - Reset password

Let's reset the default administrator's password to 'admin'