Multiple currencies in one column

Topic Labels: Formulas
1480 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello – I’m creating a database of projects for a company with offices in multiple companies.

Ideally I’d love to be able to input a budget value into a column and have it auto assign a currency based on the office location. Is there an example or a best practice for how to achieve this?

1 Reply 1

Welcome to the community, Mark! :grinning_face_with_big_eyes: Unfortunately Airtable’s currency formatting options are very limited. Not only is there no way to change the default formatting, but that lone formatting choice applies to all values in the same field.

The only way around this would be to craft your own custom formatting formula, but that would put the resulting formatted currency in a new field, not the same field where it was entered. Something to keep in mind. In the meantime, perhaps check to see if there’s a request in the Product Suggestions category for more currency formatting options, and add your input there. If not, feel free to start a new thread.