Google Drive and Apps Script examples

Google Sheets

=IF(ISERROR(IF(D415 = I$1,1,INDEX(GOOGLEFINANCE(D415&I$1,"price",A415),2,2))*C415),C415,IF(D415 = I$1,1,INDEX(GOOGLEFINANCE(D415&I$1,"price",A415),2,2))*C415)
- D415 refers to the target currency code (e.g. AUD)
- A415 refers to the original date
- C415 refers to the value we’re converting

Name		Name	Last commit message	Last commit date
Latest commit History 23 Commits
calendar		calendar
drive		drive
gmail		gmail
spreadsheet		spreadsheet
README.md		README.md
utilities.js		utilities.js