You can apply formatting to a number field by double clicking the field name, selecting customize field type, and then formatting.
Note that for the examples above, the output of a formula can initially be a plain number string, and not have any formatting. You'll need a field to track hours ( number field), another to track wages ( currency field), and a final field ( formula field) to enter as a formula. Multiplyingįor example, let's say you'd like to calculate the total wages for a team of hourly staff. Airtable is a relational database so formulas are applied for the entire field (column) so that the same formula applies to every record in that field. In a spreadsheet, you can put a formula in any cell, and have it reference any other cell in the sheet.
This article covers how to add, subtract, multiply, and divide using a formula field. Because of the way Excel handles percentages, it sees these formulas as exactly the same thing. If you're new to Airtable and are ready to start building out formulas, you'll notice that formulas in Airtable are slightly different from traditionally spreadsheet programs like Excel or Google Sheets.
