---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Add a formula to a column in Table Builder

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

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](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.

## Before you begin

* The scope of the table should be within the scope of the application. Otherwise, you cannot add a formula to a column in the table that is outside the scope of the app.
* Role required: personalize_dictionary or AES user role and delegated developer permissions. For more information, see [Delegate developers using AES](https://servicenow-prod.fluidtopics.net/7nGx8ej0_uG1DIiyMPiwOA "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).").
{#add-formula-column-table-builder__ul_e2f_lrd_g5b}

## Procedure

1. From the Data or Forms tabs, click the Open side panel icon (![Open side panel icon]()) for a column.
2. In the Config tab of Formula section, click + Add.
3. Enter a predefined function or a formula in the Formula editor modal.  
   For example, to concatenate the First name column value with the Last name column value and populate the Full name column value, enter `CONCATENATE(first_name,last_name)`. For more information about
   available predefined functions and example formulas, see [Formulas for column values in Table Builder](https://servicenow-prod.fluidtopics.net/_maTXVWDWgcPD79Ujne7tw#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.")  
   For syntax guidance and examples, click the function in the auto-suggestion that appears as you begin typing.  
   Note:  
   You cannot add a formula for unsupported columns, columns that are function fields, and the columns that already have script as the calculated value type.
4. Click Submit.

## Result

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