Be one of our first users and enjoy an exclusive 50% lifetime discount. Learn more

Column management

Click on any column header to open the column options menu. From here you can rename, edit settings, change the color, change the type, sort, filter, insert adjacent columns, pin, hide, or delete the column.

Rename

Renames the column. Click "Rename" and type a new name directly in the column header.

Edit

Opens the column settings panel where you can update the column's configuration depending on its type. See the column type breakdowns below for what each Edit panel contains.

Change color

Changes the color of the column header for easier visual identification. Available colors are: Red, Green, Orange, Yellow, Pink, and Default (no color).

  1. Click "Change color" in the column options menu.
  2. Select a color from the submenu. The column header will update immediately.

Change type

Changes the data type of the column. Available types are: Text, Link, Number, Email, Date, Currency, Image from URL, Select, Checkbox, and Formula. Changing the type may affect how data in the column is displayed or processed.

  1. Click "Change type" in the column options menu.
  2. Select the new type from the submenu.

Column type: Text

Stores plain text values. The Edit panel includes a "Text preset for all rows" field — enter a value here to pre-fill all rows in this column with the same text (e.g. "USA").

Column type: Currency

Stores monetary values with a currency symbol. The Edit panel includes a "Currency code" dropdown (default: US Dollar) and a "Text preset for all rows" field to pre-fill all rows with a default value.

Column type: Select

Stores a value chosen from a predefined list of options. The Edit panel lets you manage the available options — each option has a color and a label. You can reorder options by dragging, rename them, delete them with the trash icon, or add new ones with "+ Add option". Click "Save" to apply changes.

Column type: Formula

Computes a value based on other columns using either an AI-generated formula or a manually written one. The Edit panel has two modes:

  • AI Formula — Describe what you want in plain language and let AI generate the formula for you.

    • Type a description in the "Describe the formula you want" field (e.g. "get the value after @ in /email").
    • Type "/" to insert a column reference into your description.
    • Click "Generate" to have AI produce the formula.
  • Text with tokens — Combine static text and column values to build a custom string.

    • Switch to the "Text with tokens" tab.
    • Type your text and use "/" to insert column tokens (e.g. /First_name /Last_name).

You can also write your own formula directly in the "Or write your own formula" field using column tokens (e.g. {{email}}?.split("@")?.[1]). Click "Test" to validate it before saving.

Sort A–Z / Sort Z–A

Quickly sorts the entire table by this column in ascending or descending order.

Filter on this column

Opens the filter panel with this column pre-selected, so you can quickly apply a filter condition without navigating to the toolbar Filter menu.

Dedupe

Quickly remove duplicated rows from column.

Insert column left / Insert column right

Inserts a new column immediately to the left or right of the current column. Clicking either option opens the same column type submenu (Text, Link, Number, Email, Date, Currency, Image from URL, Select, Checkbox, Formula) so you can choose the type of the new column.

Pin column

Pins the column to the left side of the table so it stays visible when scrolling horizontally.

Hide

Hides the column from the current view without deleting it. You can make it visible again from the Columns panel in the toolbar.

Delete

Permanently deletes the column and all its data. This action cannot be undone.

Table of content:

line background

Learn from the best in our private Slack community.

Join a network of industry leaders and gain exclusive insights, tips, and strategies.

Join community