Skip to main content



Create a formula in a worksheet


Explains what the feature is or what its benefits are to the user or customer.


You can create a formula in a worksheet by using the Formula Builder. When you do this, the result of the formula gets added to the worksheet as a column.

Use these steps to create a formula:

  1. Create a new worksheet, or edit an existing one.
  2. Click the + button next to Formula.

    Create a new formula in a worksheet

  3. Type your formula in the Formula Builder.

    Use the Formula Builder

    Note: Formulas elements are color coded by type and can include the formula operators and functions? (blue), the names of columns (purple)?, and/or constants? (black).
  4. If you want to change what your formula returns, use the Advanced settings.
    Depending on your formula, you may be able to change:
    • Data type
    • Aggregation type

    Advanced settings in the Formula Builder

  5. You can see a list of formula operators with examples by clicking on Formula Assistant.

    Examples in the Formula Assistant

  6. Name the formula by clicking on its title and typing the new name. Click Save.
  • Was this article helpful?