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!