Formulas

Automatically calculate values in your database.

Formulas let you create columns that calculate values automatically based on other columns.

What You Can Do

  • Add up numbers (totals, subtotals)
  • Calculate days until a deadline
  • Combine text from multiple columns
  • Show different values based on conditions

Examples

Days Until Due

Shows how many days until each task is due. Negative numbers mean it's overdue.

Full Name

Combine first name and last name into one column.

Total Price

Multiply quantity by unit price.

Status Label

Show "Done" if a checkbox is checked, "Pending" if not.

How to Create a Formula

  1. Add a new column
  2. Choose Formula as the type
  3. Write your formula using column names
  4. The values calculate automatically

Tips

  • Reference other columns by their exact name
  • Formulas update automatically when source values change
  • Start simple and build up complexity as needed