Formula

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.