Formula
The Formula field calculates values from fixed numbers, record fields and connected records, with functions like IF, CONCAT and DATEDIFF.
In short
- What you can do: combine text values from multiple fields using CONCAT; perform arithmetic operations (addition, subtraction, multiplication, division); apply conditional logic with IF.
- How to start: On table mode, click the "+" on the last table header.
- Keep in mind: The Formula field does not update in real time on every keystroke.
For instructions on how to access field types or how to add one, see Field Types.
Capabilities
- Combine text values from multiple fields using CONCAT
- Perform arithmetic operations (addition, subtraction, multiplication, division)
- Apply conditional logic with IF
- Extract or format date and time values
- Calculate differences between dates with DATEDIFF
- Use fields from connected records in the expression
- Define the return type of the formula result
How to add a Formula field
To create a Formula field:
- On table mode, click the "+" on the last table header
- Search for Formula and click on it
- Name the field and write your formula
Basic operators
Addition: +
Subtraction: -
Division: /
Multiplication: *
Functions
IF: Returns a value if a condition is true and another if it's false.
Reference
IF(condition, value_if_true, value_if_false)CONCAT: Concatenates two or more text values.
Reference
CONCAT(expression1, expression2, expression3, ...)ROUND: Rounds a number to a given number of decimal places.
Reference
ROUND(number, decimals)POW: Returns a number raised to the power of another.
Reference
POW(x, y)NOW: Returns the current date and time.
Reference
NOW()DATE_FORMAT: Formats a date value as specified.
Reference
DATE_FORMAT(date, format)TIME_FORMAT: Formats a time value by a specified format.
Reference
TIME_FORMAT(time, format)DATE_ADD: Adds a time/date interval to a date and returns the result.
Reference
DATE_ADD(date, INTERVAL value addunit)DATE_SUB: Subtracts a time/date interval from a date and returns the result.
Reference
DATE_SUB(date, INTERVAL value interval)DATEDIFF: Returns the number of days between two dates.
Reference
DATEDIFF(date1, date2)MICROSECOND: Returns the microsecond part of a time/datetime (0–999999).
Reference
MICROSECOND(datetime)SECOND: Returns the seconds part of a time/datetime (0–59).
Reference
SECOND(datetime)MINUTE: Returns the minute part of a time/datetime (0–59).
Reference
MINUTE(time)HOUR: Returns the hour part of a time/datetime (0–838).
Reference
HOUR(time)DAY: Returns the day of the month for a given date (1–31).
Reference
DAY(date)MONTH: Returns the month part for a given date (1–12).
Reference
MONTH(date);YEAR: Returns the year part for a given date (1000–9999).
Reference
YEAR(date)DATE: Extracts the date part from a datetime expression.
Reference
DATE(expression)Use cases and examples
- In a Leads table, use CONCAT to combine a contact's name, company name, and a message text to help send automated emails.
- In a Leads table, use YEAR on a date field to extract the contact year and create a filter for leads by year.
- In an Inventory table, subtract the minimum required stock quantity from the current quantity to visualize how many units can be sold.
- In a Financial Statement table, subtract taxes from a record's value to quickly display the net amount.
Keep in mind
- The Formula field does not update in real time on every keystroke. It recalculates when the record is saved.
- It does not support aggregation across multiple records (e.g., summing all values in a column). For that, use a Rollup field.
FAQ
1- Can I reference fields from connected tables in my formula?
Yes. You can use fields from connected records directly in your formula expression, not just fields from the same record.
2- Can I use multiple functions together in a single formula?
Yes. Functions can be nested and combined. For example, you can wrap an IF inside a CONCAT, or use DATE_FORMAT around a DATE_ADD result.
Updated 18 days ago
