Simple conversion formula

Platform discussions Special workflows & use cases
1

Hi all,

I have been trying to insert an automated conversion through the formula below but could not get it to work. Any help or tips is much appreciated!

IF({Currency#Labels}=“USD”,ROUND(SUM({Amount}*2)),IF({Currency#Labels}=“EUR”,ROUND(SUM({Amount}*4)),IF({Currency#Labels}=“GBP”,ROUND(SUM({Amount}*7),0))))

So the basic logic is:
if currency column shows USD → Multiply the data in “amount” column by 2
if currency column shows EUR → multiply the data in “amount” column by 4
if currency column shows GBP → multiply the data in “amount” column by 7

However, with this formula, only the last part works (GBP condition). Whenever I choose USD or EUR in the “currency” column, it breaks down.

Thanks a lot in advance for all the tips!

2

@thekid

You might try this:

SWITCH({Currency#Labels}, 
   "USD", ROUND({Amount}*2,0),
   "EUR", ROUND({Amount}*4,0),
   "GBP" ,ROUND({Amount}*7),0),
   "ERROR"
)

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

3

Hey Jim, did a couple tweaks and it worked. Thank you very much!