---
sourceDocument: Australia Strategic Portfolio Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/pt-BR/it-business-management

 Release :

    - australia

ft:locale :

    - pt-BR

ft:publication_title :

    - Australia Strategic Portfolio Management

ft:clusterId :

    - itbm

bundleId :

    - itbm

workflow :

    - Technology


---

# Add a formula column

# Add a formula column in CWM Boards {#ariaid-title1}

* Versão de lançamento: Australia
* 
* Atualizado 12 de mar. de 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 min. de leitura

Gain deeper insights into your work by adding formula columns to your List view in CWM Boards. Create calculations that automatically compute values for your tasks, such as summing hours, calculating date differences, or deriving metrics from existing fields.

## Antes de Iniciar

[Create a Board in CWM](https://servicenow-prod.fluidtopics.net/UTSHEiFdqARLH4CsZiONoQ "Manage work assigned to your team as tasks and track them to completion using customizable Boards for your shared Spaces in Collaborative Work Management.").

Role required: sn_cwm.cwm_user

You need to have either Editor or Owner access to the Space to add a custom column.

## Por Que e Quando Desempenhar Esta Tarefa

Formula columns in the List view of a CWM Board compute values from existing CWM columns. Examples include calculating date differences from existing Date columns or deriving metrics such as Profit from existing values of
Revenue and Cost columns.

Use the built-in Math, String, Date \& Time, and Logical functions in the Formula Builder side panel to define a formula expression. To automatically generate a formula from a plain language description using Now Assist instead, see [Generate a formula using Now Assist for CWM](https://servicenow-prod.fluidtopics.net/WXQnZhE7GTPSEkc6VQ0isQ "Use Now Assist to automatically generate formulas to compute values such as summing hours, calculating date differences, or deriving metrics from existing fields.").

The steps in this procedure use the example of a formula column that calculates the number of days remaining until a task's due date. Follow the steps as guidelines to build a formula of your choice.

## Procedimento

1. Navigate to WorkspacesCollaborative Work Management.
2. From a Space, open the Board where you want to add a formula column.
3. In the List view of the Board, select Add column from the column header and select Formula.  
4. Provide a name for your formula column.  
   In this example, the column is named Days until due.
5. In the Define Formula side panel, use the Math, String, Date \& Time, and Logical functions to build your formula.  
   To arrive at the number of days remaining from the due date, use the Date \& Time functions to build a formula that calculates difference (in days) between the current day and the due date.

   DATEDIF(TODAY(),"Due Date","D")
6. Select Set Formula to save and apply the formula column.

## Resultado

* The Board refreshes to display the new formula column, and its values populated per the formula you defined.
* If your formula contains any syntax errors, you are notified of the same and then you can review it and correct it.

{#add-formula-column-cwm-boards__ul_bhn_pt3_m3c}
**Tarefas relacionadas**   

* [Add custom columns for tasks in a CWM Board](https://servicenow-prod.fluidtopics.net/ZTQlruL0QLhSeoklmDzBQg "Create custom fields in a Board so that you can organize all details of tasks at a single location, thereby improving task management and saving time by reducing dependency on system admin.")
* [Generate a formula using Now Assist for CWM](https://servicenow-prod.fluidtopics.net/WXQnZhE7GTPSEkc6VQ0isQ "Use Now Assist to automatically generate formulas to compute values such as summing hours, calculating date differences, or deriving metrics from existing fields.")