The table below lists the terms you'll encounter and some common examples of each one.
Word | Usage | Example |
Curly Bracket | Reference a {Column Name} | {Price} or {Status} |
Function | References a formula function that performs specific calculations using specific column names | SUM ({Value 1}, {Value 2}) or AVERAGE ({Value 1}, {Value 2}) |
Operator | Symbols used in formula to output different calculations |
|
String | Group of text characters that are used in the formula. String input need to be given in double quotes. | “This text needs to be changed” |
Array | Collection of values separated by a comma | Price 1, Price 2, Price 3 |
Integer | Whole number - positive, negative or zero | 9 |
Date | A date format that can be represented in multiple ways | January 1st, 2022
|
