View or edit a formula in a search

The formula editor redesign is part of the new answer experience. The new answer experience is in Beta and off by default, but the option to turn it on or off individually is on by default. If you have the new answer experience on, your user interface and experience may be different from the experience described in this article. You can turn the new answer experience on or off individually from the Experience manager panel in your profile. If that option is not available, contact your administrator.

Learn how to view or edit a formula.

You can always go back and view or edit a formula that was added to a search. Do this by clicking the edit icon next to its name in the Columns listing. Anyone who has edit privileges on an answer can also edit any formulas it contains. To view or edit an existing formula in an answer:

  1. Navigate to the pinboard that contains the answer with the formula, click the More menu icon more options menu icon and select Edit.

  2. Scroll down to the bottom of the Columns listing. You will see a data source called Formulas.

  3. Expand Formulas, and you can see a list of all the formulas in this answer.

    edit formula in answer
  4. Click the edit icon edit icon next to the formula name.

  5. View or edit your formula in the Formula Builder.

    formula builder 2
    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).
  6. If you edited your formula, click Save to save your changes. Otherwise, click Cancel.