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
- Add a new column
- Choose Formula as the type
- Write your formula using column names
- 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