Hour 3-4: Working with Formulas and Calculations
Basic calculations in Airtable using formulas:
Introduce the concept of formulas in Airtable Explain that formulas are used to perform calculations and transformations on data within a table Highlight that formulas can be applied to various field types, such as numbers, dates, and text Overview of commonly used formulas and functions:
Present examples of commonly used functions in Airtable, such as: Arithmetic functions: SUM, PRODUCT, DIVIDE, etc. Text functions: CONCATENATE, LEFT, RIGHT, MID, LEN, etc. Date functions: DATEADD, DATEDIF, TODAY, etc. Conditional functions: IF, AND, OR, etc. Lookup and reference functions: LOOKUP, MAX, MIN, etc. Demonstrate how to use these functions in combination to create more complex formulas Hands-on exercise: Implementing basic calculations using formulas
Instruct students to create a new table within the existing base to track the progress of tasks Ask students to add the following fields: Task ID, Task Name, Status, Start Date, Due Date, and Days Remaining Explain that the "Days Remaining" field will be calculated using a formula Guide students through creating the formula for the "Days Remaining" field using the DATEDIF and TODAY functions, as well as conditional statements Encourage students to experiment with other formulas and functions to perform additional calculations, such as calculating the duration of tasks, determining the percentage of tasks completed, or identifying overdue tasks By the end of this session, students should have a good understanding of how to use formulas and calculations in Airtable to perform various data manipulations and transformations.
Day 3 - Hours 3-4