This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results forย

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

- Airtable Community
- Product Ideas
- Add a CURRENCY() function for Formula Fields

Idea Options

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Add a CURRENCY() function for Formula Fields

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results forย

Kamille_Parks

16 - Uranus

Comment Post Options

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

โDec 20, 2018
01:44 PM

Right now, to format values pulled from a Currency field in a Formula field, users have to use something akin to the following formula to get โ$65,756โ to display as such. Otherwise, AirTable displays it as โ65756โ, no commas, no currency symbol:

IF( LEN(CONCATENATE({Trip Budget}))<4, {Trip Budget}, IF( AND(LEN(CONCATENATE({Trip Budget}))>3,LEN(CONCATENATE({Trip Budget}))<7), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-3)&","&RIGHT(CONCATENATE({Trip Budget}),3), IF( AND(LEN(CONCATENATE({Trip Budget}))>6,LEN(CONCATENATE({Trip Budget}))<10), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-6)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3), IF( AND(LEN(CONCATENATE({Trip Budget}))>9,LEN(CONCATENATE({Trip Budget}))<13), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-9)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),9),3)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3), ) ) ) )

This is obviously inconvenient, and it doesnโt even take into account decimals or amounts greater than $999,999,999.

I propose a new formula function that operates something like this:

CURRENCY([number or field reference], [currency symbol]) => CURRENCY(12345.6,"$") = $12,345.60

See more ideas labeled with:

29 Comments

Recently Completed Ideas

Idea Statuses

- New Ideas 500
- Already in product 10
- Considering 0
- In development 0
- Not on the roadmap 1
- Launched 22