Multiple currencies in board? Or no?

Hi - we have a Projects board that services clients in both the UK and US. We have an integration with Xero which will send items over automatically for invoicing.

However right now our billing columns (like rates, revenue, etc) are all in GBP. For our US clients I need them to display in USD so they appear as USD in Xero.

Is there a simple formula I can add which will look at the Country column and then simply say “change the currency in these columns to USD if the country column is USA”?

Thanks in advance.

We are in the same boat. We are in the UK but need to bill some of our overseas customers in USD, and possibly in the future in Euros! We can’t be alone in having this challenge.

IF({Country}=“USA”, “USD”,”GBP”)