Currency conversion in another column

[Weiwei (Weiwei Cheng)]

I have a default currency field (Budget TWD) and another currency field is (Budget USD). May I know how to I code in formula instead manually type the USD$ in the Budget USD field.

[BiancaT (Bianca Taylor)]

Hey @Weiwei,

Could you set up a numbers column to log the exchange rate which you could integrate into the formula?

In addition, the general caster app has a recipe available that automatically converts currencies based on a column change:

I hope this helps!