---
sourceDocument: Brazil Build or modify applications
sourceDocumentLink: https://www.servicenow.com/docs/r/application-development

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Add a formula to a column

# Add a formula to a column in Table Builder {#ariaid-title1}

Release version: Brazil  
Updated October 22, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Use a predefined function or create a formula to calculate a value for a column without writing a script in Table Builder. You can use two or more functions to create a formula according to your requirements.

## About this task

The following limitations apply when adding formulas to columns:

* You can add a formula to a column only if the table is in the same scope as the application.
* You can't add a formula to unsupported columns, function field columns, or columns that already use a script as the calculated value.
{#add-formula-column-table-builder__ul_m1x_3g3_zkc}

## Before you begin

Role required: formula_read and either personalize_dictionary or AES user role and delegated developer permissions. For more information, see the following resources:

* [Delegate developers using AES](https://www.servicenow.com/docs/MJRNdYSPXp_Bz4loYKjYyw "Delegated development enables designated users without a system admin role to develop or deploy applications on the ServiceNow AI Platform. This enables administrators and delegated developers to work together to deliver custom applications through App Engine Studio (AES).")
* [Accessing Table Builder](https://www.servicenow.com/docs/QaNGN5egPXTWrz2ywzjhhA "You can access Table Builder in several ways.")
{#add-formula-column-table-builder__ul_ykr_zg3_zkc}

## Procedure

1. From the Data or Forms tab, select the Open side panel icon (![Open side panel icon]()) for a column.
2. In the Config tab of the Formula section, select + Add.
3. Enter a predefined function or a formula in the Formula editor modal.  
   For example, to combine the First name and Last name column values into a Full name column, enter `CONCATENATE(first_name,last_name)`. For syntax guidance and examples, select a function in the
   auto-suggestion list as you type. For all available functions, see [Formulas for column values in Table Builder](https://www.servicenow.com/docs/_rNNrPhilKh7g4PvtIdODA#formulas-columns-table-builder "You can use a predefined function and create a formula to calculate the value of a column without writing a script. Use a predefined function or create a nested formula by using the existing predefined functions to calculate the column value type.").  
   Note:  
   A formula can use only fields that you have read access to, including fields reached by dot-walking.

4. Select Submit.

## Result

The formula is validated and added to the column if it doesn't have any errors.