![]() ![]() 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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |