Adding formula fields to tables

Prev Next

Follow these steps to add a formula field in a table:

  1. To add a formula field in a table, go to Fields in the table's settings and select New fields.

  2. Select a field type for the formula.
    The New fields dialog showing formula field type options

  3. Add a label and select Add fields.

Enter the formula

Once you add the field, you'll see the list of fields for the table. If you don't see the fields, go to the table's Settings menu and select Fields.

  1. From the list of fields for the table, select the formula field.
    A formula box displays, which is a working space for you to write your formula.

    Learn more about different field types in Formula field types.
    The formula editor box in a field's settings

  2. Select the formula box to start typing or select Choose fields & functions to add functions to your formula.

  3. Finish setting up the field, and then select Save.

Up next