Converting currencies

MONDAY.CURRENCY converts an amount from one currency to another at the latest daily rate; the currency block does it from one column to another.

MONDAY.CURRENCY(amount, from, to) converts an amount at the latest daily exchange rate. The currencies are three-letter codes such as EUR, USD, GBP or JPY. More than 160 currencies are supported.

=ROUND(MONDAY.CURRENCY({item's Price}, "EUR", "USD"), 2)

This gives the price in US dollars, rounded to cents.

• A list converts item by item: MONDAY.CURRENCY(VALUE(TEXTSPLIT({item's Prices}, ", ")), "EUR", "USD").
• An unknown currency code gives #N/A.
• An empty amount stays empty.

The currency block does the same without writing a formula. You choose the column with the amount, the two currencies and the column to write into; the result is rounded to 2 decimals unless you ask for others. Without a target column, the block passes the result to the next step of the workflow.

Rates are updated once a day. They are reference rates, suited to estimates and reports, not to payments.

Rates by ExchangeRate-API.

Available in the recipes created from November 2026 and in the new automation blocks.