
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 22, 2017 12:07 AM
Hey AT community!
Been working with Airtable for only a little while now and having trouble coming up with a formula that we will use in many of our tables.
I would simply like to input an amount in a USD$ field and have it automatically appear in the €EUR field by multiplying it against an exchange rate (ie. 0.93) Often, we receive both currencies in sales or donations.
In other words, if the Euro field is empty and the sale was in USD, we could enter the USD and exchange rate and have it calculate and populate the Euro column.
Here’s a screenshot of the columns and what I’m trying to figure out. How would you suggest I do this? Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 02, 2018 08:10 PM
Hi Filipa Didier
There is a MESSAGE option, maybe you could PM him. I just did a quick check and it seems this person has not posted anything since January, I could be wrong though, but I thought I would let you know.
MK
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2019 12:56 AM
Has anyone figured this one out? I’m used to coming from Google Sheets where I can pull in an array formula which can get GoogleFinance to autocalculate currencies, and I’m hoping to move everything over to Airtable though.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 03, 2019 06:56 PM
exactly same here, no good solution found.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 14, 2019 09:03 PM
Airtable… please add a CURRENCY(‘USDGBP’) type function
:pleading_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 13, 2020 12:43 AM
Does anyone know how to use this script?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2021 02:33 AM
I also need to convert currencies in another column. Anyone figure this out?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2021 07:41 AM
@Joseph_Tandle Maybe our app will help with this? Its for bulk converting one currency to another. We also allow the use of a date column to ensure the exchange is historically accurate. Currency Converter - Apps - Airtable Marketplace
Any features missing that wll solve your problems - we’d love to know :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 19, 2022 04:15 AM
The Data Fetcher extension will let you convert currency in bulk easily in Airtable!

- « Previous
-
- 1
- 2
- Next »