Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Create range of number for currency or number

Solved
Jump to Solution
325 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello Guys,

Thanks for reading this and taking the time to help me out :slightly_smiling_face:

I’am trying to customize my project management table and more precisely to implement a budget line.
Thing is that the budget is not a fix number but a range. When i try to use the currency or the number field i’am stuck with only one possible number.

Could you help me to fix this ?

Cheers

1 Solution

Accepted Solutions

Welcome to the community, @Aurelien_G! :grinning_face_with_big_eyes: As you’ve discovered, value ranges aren’t allowed in currency or number fields. The best you can do is enter the start and end values of the range into separate fields. If you want to see those combined into a single field, a formula will allow you to do that, though you’ll run into another fun fact about Airtable: while there’s a function for formatting dates, there isn’t one for formatting numbers. The formatting that you see in currency and number fields is there for display purposes only, and doesn’t get passed to formulas that read those fields.

Long story short, if you want your currency/number values re-formatted, your formula will need to take care of that. There are discussions on number formatting elsewhere in the forum, but there’s also a really slick app called “Ready-Made Formulas” by @kuovonne that contains lots of formulas for specific use cases, including number formatting.

See Solution in Thread

2 Replies 2

Welcome to the community, @Aurelien_G! :grinning_face_with_big_eyes: As you’ve discovered, value ranges aren’t allowed in currency or number fields. The best you can do is enter the start and end values of the range into separate fields. If you want to see those combined into a single field, a formula will allow you to do that, though you’ll run into another fun fact about Airtable: while there’s a function for formatting dates, there isn’t one for formatting numbers. The formatting that you see in currency and number fields is there for display purposes only, and doesn’t get passed to formulas that read those fields.

Long story short, if you want your currency/number values re-formatted, your formula will need to take care of that. There are discussions on number formatting elsewhere in the forum, but there’s also a really slick app called “Ready-Made Formulas” by @kuovonne that contains lots of formulas for specific use cases, including number formatting.

Hello Justin ! :slightly_smiling_face:

Thank you for your feedback and informations !

Best,
Aurélien