[Custom function] Get the current date and time by the timezone

Here is a custom function to get the current date and time by the timezone.   Source code   Parameters tz … timezone name (ex: GMT, UTC, ECT, JST…)   Responses date and time (string format)   How to know the codes of time zones? Please refer the following post; The list of time zones

[Custom function] List all sheet’s names

Here is a custom function to list sheet’s names.   Source code   Parameters None   Returns None   References Count sheets Get range object by row and column number Edit cell’s value Get sheet name and sheet id [Custom function] Get sheet name

Select a sheet

Here is how to select or activate a sheet. Source code Steps (1) Get a target sheet object Please refer the following post; Get a sheet object by name (2) Activate a targeted sheet Please refer the following post; Activate a sheet

[Custom function] Get sheet name

Here is how to create custom function to get sheet name. If you just want to know a tip to get sheet name, please refer the following post; Get sheet name and sheet id Source code function getSheetName(){ var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sh = spreadsheet.getActiveSheet(); var shName = sh.getSheetName(); return shName; } Parameters No … Read more [Custom function] Get sheet name