Day 3 - Hours 3-4

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.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.