> This page is for Glide Classic.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://www.glideapps.com/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/docs/_mcp/server.

# Computed Columns

> Transform basic data in powerful new ways.

The [Data Editor](/docs/getting-started/introduction-to-the-data-editor) is where you edit the data in your [Glide Table](/docs/essentials/data-sources/glide-tables) or external [Data Source](/docs/essentials/data-sources). It's also where you can add powerful Computed Columns that enhance your app's data.

This guide gives you an overview of the six most commonly used types and directs you to more in-depth documentation on each of them.

## Relation Column

#### Computed Columns - Arcade 1

After making a few Lists and [Screens](/docs/getting-started/intro-to-layout/screen-types) in Glide, many people realize that they need to create relationships between things. For example:

* Allow tasks to belong in apps
* Show employees inside of departments
* Put inventory items into categories
* Or map rooms belong inside of buildings

Databases like [Airtable](/docs/essentials/data-sources/airtable) allow us to create relationships like this, but normal spreadsheets don't.

Wherever your data is stored, you can use the Relation Column to create relationships and then use those relationships in lots of different ways.

## Lookup Column

#### Computed Columns - Arcade 2

The [Lookup Column](/docs/automation/computed-columns/lookup-column) uses a Relation to look through and bring back the values from a single column. For example:

* Retrieve the phone number of a team member's manager
* Show the app name that the current task belongs to
* Lookup the category ID for the current item
* Get the address of the customer assigned to this order

## Template Column

#### Computed Columns - Arcade 3

The [Template Column](/docs/automation/computed-columns/template-column) lets you display dynamic text from data found in other columns. For example, you could write '**Welcome NAME, today is DAY**' and replace **NAME** with the User's name and **DAY** with the current day.

## Rollup Column

#### Computed Columns - Arcade 4

The [Rollup Column](/docs/automation/computed-columns/rollup-column) helps you to perform a calculation on an entire column or even a Relation. The most basic computation for the Rollup is Count, but depending on what data you're working with, you can also do things like: Count Unique, Sum, Average, Range, Max/Min, Earliest, Latest, Count True, All True, and much more.

## Math Column

#### Computed Columns - Arcade 5

The Math Column performs instant calculations on the data in your table—from basic arithmetic functions to more complex ones. You can then use these formulas in  different [Components](/docs/essentials/components) in your app and see the output instantly.

## If → Then → Else Column

#### Computed Columns - Arcade 6

The If → Then → Else Column produces new values based on a set of conditions. For example:

* If the user's age is greater than 18, output the value **Of Age**
* If the **Task Relation** column is empty, output the value **No Tasks**
* If the **Due Date** is before today, output the value **Overdue**
* If the user's **score** is greater than 60%, output the value **Pass**