> For the complete documentation index, see [llms.txt](https://docs.mashmatrix.com/mashmatrix-sheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/union_sheet/overview.md).

# Overview

A union sheet displays records of the multiple Salesforce objects you have selected together in a single table. One row corresponds to one record, and each row represents a record of one of the objects.

<figure><img src="https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2F8vJB0bJzuZVrxgEpwMHG%2FCleanShot%202026-08-26%20at%2008.34.39%402x.png?alt=media&amp;token=8ebe76e1-ba2f-4135-ae5b-71b031f9b1de" alt=""><figcaption></figcaption></figure>

## Column Types <a href="#column-types" id="column-types"></a>

There are the following three types of columns in a union sheet.

* **Union Column** - A column that displays and edits fields of each of the united objects together in a single column. Fields with compatible data types can be mapped to each other.
* **Single-Source Column** - A column that displays and edits the field of only one of the united objects. In rows of an object to which the field is not assigned, the cell is blank and cannot be edited.
* **Object Type Column** - A dedicated column that indicates which object each row's record belongs to.

Each object that makes up a union column is called a **source object** of that column. You can check and change which field is mapped to which column from the column setting. For details, see "[Add and Configure Columns](/mashmatrix-sheet/functions_advanced/union_sheet/add_and_configure_columns.md)".

## Edit Controls <a href="#editor-controls" id="editor-controls"></a>

The edit control used when editing a cell of a union column follows the field definition of the object of that row. Even in the same column, a different edit control is displayed depending on the object of the row.

For example, in a sheet uniting contacts and leads, if you put the "Account Name" field of the contact and the "Company" field of the lead into a single union column, rows of contacts use lookup editing and rows of leads use text editing.

## Object Type Column <a href="#object-type-column" id="object-type-column"></a>

A union sheet always contains an "Object Type" column that indicates which object each row's record belongs to. The value of this column is the name of the object selected when the union sheet was created.

The "Object Type" column can be used as a condition for filtering, sorting, and formatting in the same way as other columns. To display records of a specific object only, set a filter on this column.

For a newly added row, you select from the picklist of this column which object the record is created as. For details, see "[Edit Records](/mashmatrix-sheet/functions_advanced/union_sheet/edit_records.md)".

{% hint style="warning" %}
The "Object Type" column is required for a union sheet and cannot be deleted. If you have included this column in a group column, that group column cannot be deleted either. It can be set to hidden.
{% endhint %}