Examples

Common formula recipes for Noloco — joining text, replacing parts of strings, adding days to dates, and basic calculations.

A collection of common formula patterns. Field references appear in green in the examples below.

For the full reference, see the Operators pages. For setup steps, see Creating a formula field.

Joining text fields

Create a full name from a first name and last name, adding a space in between only if both fields have a value:

first name `` ``& ``IF(OR(ISBLANK(first name),ISBLANK(last name)),""," ")`` &`` ``_<mark style="color:green;">**last name`**_

Replacing part of a text field

Replace "-old" with " (discontinued)" for a nicer record view:

SUBSTITUTE(name, "-old", " (discontinued)")

Adding days to a date

Create a deadline one week after an important date:

TODATE(important date + 7)

Adding working days to a date

Create a deadline several working days after an important date, taking holidays and weekends into account:

TODATE(WORKDAY(important date, 3, {"2024-06-03","2024-12-25"}))

Calculations

Calculate gross sales:

(number sold-number refunded)*price