Two (2) columns of expenses in different currencies
I work for an international agency
I have to submit a report of expenses. I have some expenses in US dollars and some in Euros. I would like 2 columns and then a conversion column in euros - how can I do that ?
Question
Two (2) columns of expenses in different currencies
+1I previously built a solution for a similar use case, where I created one field for the amount, another field for the currency, and a third field (a formula or automation agent) that converts the entered amount into USD using the exchange rate at that time (fetched from the internet).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.