Hello there,
I would like to set a different currency on every line. Like a supplier from France in Euros and one from USA in dollars. And the sum of the column in Swiss franc, with automatic conversion.
Example:
Line 1: $50
Line 2: £23
Line 3: €98
TOTAL in €
Is this possible?
Many thanx,
Céline
Hi Céline.
The only way that I can imagine to accomplish what you need is by setting up three columns in your board:
(1) The amount expressed in the original currency
(2) The conversion rate between the currency defined in (1) and Swiss Franc
(3) Formula type field representing the amount expressed in Swiss Franc: (1) * (2)
Marvellous answer @agranville,
But for a wonderful app like Monday we could imagine an nice column who can do the conversion by itself and we could change the rate in one unique place.
You solution is great but we have to change every conversion rate one by one if it change a lot.
I hope they will do something like that in a futur release.
Have a nice day
My two cents - I would also be interested in multi-currency support within the same column. @Celine said it very well, this is functionality that Monday should support. Would you mind letting us know where this currently stands @agranville?
Hi @Celine !
So I think I have a slightly altered solution that might help with your problem. @agranville had a great start, but we could completely eliminate the conversion rate by using an embedded IF statement to make the calculations based on the Currency choice (in the status column).
To do that, this is a great way to think about embedded IF statements:
IF(state the rule, if it is true, IF( state the second rule, if second rule is true, if neither rule is true))
Example for your situation:
IF({status} = “$”, {amount}*0.99, IF({status}=“€”, {amount}*1.09, 0)
This means that when you choose $ it will multiple the amount by 0.99 and if you choose € it will multiple it by 1.09.
Hope this helps!
