> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://www.glideapps.com/docs/automation/computed-columns/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/_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** > Transform basic data in powerful new ways. ## Docs - [Construct URL](https://www.glideapps.com/docs/automation/computed-columns/construct-url.md): Create URLs based on the different values in your table. - [Date Difference](https://www.glideapps.com/docs/automation/computed-columns/date-difference.md): Calculate the time to or from a particular date. - [Distance](https://www.glideapps.com/docs/automation/computed-columns/distance.md): Calculate the distance between two locations. - [Experimental Code Column](https://www.glideapps.com/docs/automation/computed-columns/experimental-code-column.md): Create new computed columns with JavaScript. - [Format Duration](https://www.glideapps.com/docs/automation/computed-columns/format-duration.md): Format a duration from seconds into hh:mm:ss. - [Generate Image](https://www.glideapps.com/docs/automation/computed-columns/generate-image.md): Generate an abstract image. - [If → Then → Else Column](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column.md): Produce different values based on conditions. - [Joined List](https://www.glideapps.com/docs/automation/computed-columns/joined-list.md): Join multiple values together into a single value. - [Lookup](https://www.glideapps.com/docs/automation/computed-columns/lookup-column.md): Retrieve values through a relation. - [Make Array Column](https://www.glideapps.com/docs/automation/computed-columns/make-array-column.md): Combine columns in your data source to create an array. - [ Math Column](https://www.glideapps.com/docs/automation/computed-columns/math-column.md): Perform instant calculations using the data in your app. - [Query Column](https://www.glideapps.com/docs/automation/computed-columns/query-column.md): Create complex relations in your data with conditional filtering, sorting, and limits. - [Relations](https://www.glideapps.com/docs/automation/computed-columns/relations.md): Create relationships and link rows together. - [Conditional Relations](https://www.glideapps.com/docs/automation/computed-columns/relations/conditional-relations.md): Create relationships only in certain conditions. - [Rollup Column](https://www.glideapps.com/docs/automation/computed-columns/rollup-column.md): Perform calculations on columns, such as count, average, and sum. - [Row ID Column](https://www.glideapps.com/docs/automation/computed-columns/row-id-column.md): Generate unique IDs for your rows. - [Single Value Column](https://www.glideapps.com/docs/automation/computed-columns/single-value-column.md): Retrieve a single value from a column or relation. - [Split Text Column](https://www.glideapps.com/docs/automation/computed-columns/split-text-column.md): Take a string and split it up into an array. - [Template Column](https://www.glideapps.com/docs/automation/computed-columns/template-column.md): Display dynamic text that can change with the values in other columns.