> For the complete documentation index, see [llms.txt](https://formulapro.shadebridge.com/formula-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://formulapro.shadebridge.com/formula-pro/appendix/column-types.md).

# Supported Column Types

Formula Pro supports the following column types as **trigger** and **destination** columns, unless otherwise noted.

## Supported Columns

| Column Type       | Trigger | Destination | Notes                                               |
| ----------------- | ------- | ----------- | --------------------------------------------------- |
| **People**        | ✅       | ✅           |                                                     |
| **Formula**       | ✅       | ❌           | Read only — use as trigger or source for projection |
| **Status**        | ✅       | ✅           |                                                     |
| **Date**          | ✅       | ✅           |                                                     |
| **Phone**         | ✅       | ✅           |                                                     |
| **Text**          | ✅       | ✅           |                                                     |
| **Checkbox**      | ✅       | ✅           |                                                     |
| **Numbers**       | ✅       | ✅           |                                                     |
| **Country**       | ✅       | ✅           |                                                     |
| **Dropdown**      | ✅       | ✅           |                                                     |
| **Email**         | ✅       | ✅           |                                                     |
| **File**          | ✅       | ❌           | Read only                                           |
| **Hour**          | ✅       | ✅           |                                                     |
| **Link**          | ✅       | ✅           | Format: `url:Label`                                 |
| **Location**      | ✅       | ✅           |                                                     |
| **Long Text**     | ✅       | ✅           |                                                     |
| **Rating**        | ✅       | ✅           |                                                     |
| **Tags**          | ✅       | ✅           |                                                     |
| **Time Tracking** | ✅       | ❌           | Read only                                           |
| **Timeline**      | ✅       | ✅           | Format: `YYYY-MM-DD+YYYY-MM-DD`                     |
| **Week**          | ✅       | ✅           |                                                     |
| **World Clock**   | ✅       | ✅           |                                                     |
| **Item Name**     | ✅       | ✅           |                                                     |
| **Group**         | ✅       | ❌           | Read only                                           |
| **Last Updated**  | ✅       | ❌           | Read only                                           |
| **Item ID**       | ✅       | ❌           | Read only                                           |
| **Mirror**        | ✅       | ✅           |                                                     |
| **Color**         | ✅       | ✅           |                                                     |

## Format Requirements for Destination Columns

| Column Type       | Expected Format                            |
| ----------------- | ------------------------------------------ |
| Date              | `YYYY-MM-DD`                               |
| Timeline          | `YYYY-MM-DD+YYYY-MM-DD` (start+end)        |
| Status / Dropdown | Exact label string matching column options |
| Email             | `email:Display Name`                       |
| Link              | `url:Label`                                |
| Checkbox          | `"true"` / `"false"` or boolean            |

## Read-Only Columns

These columns can be used as **triggers** or **sources** but not as **destinations**:

* Formula
* File
* Time Tracking
* Group
* Last Updated
* Item ID