Multiple currencies in board? Or no?

Platform discussions
, ,
1

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.

2

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.

3

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

4

Is this an existing solution or a proposed solution @Marius.Manic ?

5

Hi Charlie,

The only way to do this would be to add a formula column next to the numbers column containing the $$$ and to use the formula to determine the currency.
So you would get 2 columns:

2024-03-15_10-39-46

Then all you have to do is create the formula to get the currency. Something like:

IF({Country}="USA", "USD",IF({Country}="UK","GBP","€"))

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

6

Thank you, this works for our use case :+1: another Win for Monday.com