Converting text to number & formatting

[Nicole_Hawkesf1]

Please could number formatting options be implemented? At minimum, I would expect to be able to set decimal places and use of thousands comma. Even better would be to add currency symbols.

[Josh_Rutherford]

Also, please add the ability to provide more formatting options for charts. The pie chart is currently a block of colors. It would be nice to be able to put each block’s legend title and what the block represents (in this case, a percentage number) on the actual pie.

[Nicole_Hawkesf1]

Agree, and/or to sort the segments by summary field as well, like you can with bar charts - currently the pie charts feel a bit random.

[MK_Mueller]

So glad someone has raised this. I need to release several interfaces to my team and am afraid it will be non-user friendly based on the numbers being almost illegible. Currency and commas / decimals, please!

[Andrej_Perdan]

Dear Airtable,

Is international number formatting coming anytime soon?

[kuovonne]

Welcome to the Airtable community!

Andrej_Perdan:

Is international number formatting coming anytime soon?

Airtable has historically been very quiet about its plans for future features. There is a Table Talk on YouTube on Jan 20 that sounds like some roadmap info will be released. However, there is no guarantee that this level of info will be included.

For now, you can use a formula field to convert your number field to a text string with your desired formatting options. The formula is rather complex, but you can get the formula with a premium license of my Ready Made Formulas app

[Peter_Buck]

This is available now, perhaps you saw that. An example below, including totals in the legend.