How do I manage multiple currencies in the Google Sheets Itinerary export?
Easily manage and convert different currencies in your spreadsheet.
You can configure the Google Sheet generated by Safari Portal to calculate totals in multiple currencies. One quick way is to use the built-in GOOGLEFINANCE function to convert values automatically. Here’s how:
Step-By-Step Instructions
- Insert a new column where you’d like the ZAR (or other currency) conversion to appear.
- In the first cell of the column, type an equals sign (=) and then select the cell you want to convert.
- Then type *GOOGLEFINANCE("CURRENCY:USDZAR")
- Or replace USD/ZAR with the currencies you need.
- Click Enter.
- The value will convert to ZAR.
- Drag the formula down the column to apply it to the other rows.
Keywords: Google sheet, multiple currencies, convert multiple currencies, calendar builder
Did this answer your question?