Sure this is super simple and I’m no doubt being super simple myself in not getting the solution…
I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet
Col 1 [$ Charge]
Col 2 [currency selection…eg AUD, USD, GBP etc)
Col 3 [$AUD Charge]
Ultimately for each line item I add, I want all charges to be converted to AUD (this would be COL3) and from there I can run further calculation based on this number.
So I’m assuming the formulas for column 3 would be:
If “Currency” is “AUD” then display the value already entered in “$ Charge”.
If “Currency” is “USD” then multiply by “<FX rate that I’ll input>” then display the calculation as a “$ value”
I’m just not sure how I would write those formulas in Airtable?
Thanks so much