GSheet

최종 갱신일을 자동으로 입력

App script를 작성

function PutLastUpdt() {
  var sheet = SpreadsheetApp.getActiveSheet();
  // 변경일을 기록하는 셀
  var cell = sheet.getRange('C1');
  var date = new Date();
  // 변경일 포맷
  var string = "Last Updated: " + Utilities.formatDate(date, 'Asia/Tokyo', 'yyyy/MM/dd hh:mm:ss');
  Logger.log(string);
  cell.setValue(string);
}

트리거 설정
- 함수명 : PutLastUpdt
- Deploy : Head
- 이벤트 소스 : Sheet
- 이벤트 종류 : 편집시
- 에러 통지 설정 : 매일

How to use the WEEKDAY function in Google Sheets
How to Get the Sheet Name in Google Sheets (Formula)
gsheet conditional formatting based on another cell

import range from other sheet(official)

=IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1RNez4bhTMt_evAdHrFOBHeBgk1l5HAWVTb43EKpYHR8/edit#gid=0","Sales Revenue by Quarter!A1:C10”)

別スプレッドシートを参照＆自動更新 IMPORTRANGE
gsheet 他ワークブックの読み込み

Find distance from 2 address on google sheet
- https://it-soudan.com/how-to-get-distance-with-google-map-api/
Calculate Datetime to minute and others
- https://chaika.hatenablog.com/entry/2018/11/19/151434
Convert Bitcoin and ethereum price to country currency
- eg) get BTC to JPY price
```
=GOOGLEFINANCE("Currency:BTCJPY")
```
Get Bitcoin or Ethereum pricing history
- eg) BTC to JPY daily price from 367 days before
```
=GOOGLEFINANCE("Currency:BTCJPY", "price", TODAY() - 367, TODAY(), "DAILY")
```