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.
Formula screenshot

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:

  1. On table mode, click the "+" on the last table header
  2. Search for Formula and click on it
  3. 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.