← How-to guidesFormulas

Write formulas

4 steps · 5 min read

  1. 1

    Add a field of type Formula. Reference fields as {Field name}.

  2. 2

    Functions include IF, AND, OR, SUM, ROUND, CONCATENATE, UPPER, LEFT, TODAY, DATEADD, DATETIME_DIFF and more. Join text with &.

  3. 3

    The editor checks the formula as you type and shows “✓ Valid formula” or an error.

  4. 4

    With AI on, describe what you want in “Write with AI” and the formula is written for you.

Academy progress →