Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula format not displaying correctly in email automation

Topic Labels: Automations Formulas
1464 3
cancel
Showing results for 
Search instead for 
Did you mean: 
mlines
4 - Data Explorer
4 - Data Explorer

I want to send an automated email that includes a formula field/token (it is called "6-month historical average"), formatted to 0.1 decimal place (this formula calculates an avg of the numeric values in 6 other fields, all of which are to 0.1 decimal place).

Although the "6-month historical average" field is formatted to 0.1 decimal place, when I test the automation, this value always appears with a long string of decimal places e.g. instead of 4.6 it will show as 4.6248482367213....

Why is this happening? I want the historical average to show with only 0.1 decimal place.

Thanks for your advice!

3 Replies 3
Sho
11 - Venus
11 - Venus

The format is only for appearance, and internally it is such a long number.
If you want to modify the numbers, you need to process them with functions such as ROUND (UP/DOWN) or FLOOR in the formular field.

Formula Field Reference - Overview | Airtable Support

BillH
9 - Sun
9 - Sun

INT() should work as well, for example

INT({Test Float}*10)/10 where "Test Float" would be replaced by your field.  12.345678 will become 12.3

I already edited the formula to Round or Round Down, both won't work in the automated email.