If you haven't yet, start with the definitive introduction to formulas.
We're continuously adding useful functions with demo videos. Be sure you're subscribed to the newsletter and YouTube so you catch each one.
Function | Description | Example | Demo |
---|---|---|---|
dateAdd() |
Adds time to a date . |
dateAdd(prop("Date Property"), 30, "days") |
Demo |
dateSubtract() |
Subtracts time from a date . |
dateSubtract(prop("Date Property"), 30, "days") |
Demo |
Operators are one of two ways you can specify the actions to perform on your input values (the other being functions). They're the simple symbols you're mostly familiar with, like +
and >
.
Arithmetic operators perform calculations or manipulate numeric data.
Title | Symbol | Example |
---|---|---|
Addition | + |
3 + 2 → 5 |
Subtraction | - |
7 - 4 → 3 |
Multiplication | * |
3 * 5 → 15 |
Division | / |
10 / 2 → 5 |
Modulo (Remainder) | % |
10 % 3 → 1 |
Exponentiation | ^ |
2 ^ 3 → 8 |
Comparison operators evaluate conditions between two values, returning true
or false
.
Title | Symbol | Example |
---|---|---|
Equal to | == |
5 == 5 → true |
Not equal to | != |
5 != 3 → true |
Greater than | > |
7 > 5 → true |
Less than | < |
3 < 8 → true |
Greater than or equal to | >= |
5 >= 5 → true |
Less than or equal to | <= |
3 <= 5 → true |
Logical operators combine or modify boolean (true/false
) values.
Title | Symbol | Example |
---|---|---|
Logical AND | and |
true and false → false |
Logical OR | or |
true or false → true |
Logical NOT | not |
not true → false |