Mashmatrix Sheet
English
English
  • Mashmatrix Sheet User Guide
  • Introduction
  • Application Overview
  • Basic Usage
  • Functions about Books / Sheets
    • Create a New Book
    • Change Book Setting
    • Duplicate Book
    • Delete Book
    • Open Book in New Tab
    • Change Book Sharing Folder
    • Split Book Screen
    • Create a New Sheet
    • Change Tab Display Order of Sheets
    • Change Sheet Setting
      • Sheet Setting - Basic
      • Sheet Setting - Options
      • Sheet Setting - Filter
      • Sheet Setting - Actions
    • Maximize Sheet
    • Duplicate Sheet
    • Delete Sheet
    • Create a Related Sheet
    • Create a Card Type Sheet
    • Change Card Type Sheet Setting
    • Configure Views
    • Configure Search Form
  • Functions about Displaying Data
    • Change Columns Order
    • Change Column Width / Height
    • Fix Column from Scrolling
    • Sort
    • Filter
    • Change Column Setting
      • Column Setting - Basic Property
      • Column Setting - Options
      • Column Setting - Format
    • Show / Hide Column
    • Add Column
    • Delete Column
    • Group Column Headers
    • Summary Row
    • Formula
    • Function
      • Salesforce Compatible Functions
      • Aggregation Functions
      • Other Extension Functions
    • Reference Value
    • Navigate Pages and Reload Records
  • Functions about Editing Data
    • Edit / Save Displayed Data
    • Copy & Paste Values
    • Create a New Record
    • Duplicate Records
    • Delete Records
    • Lookup Search
  • Functions about Actions
    • Action Button
    • Standard Actions
    • Marketing Actions
    • Custom Actions
    • Approval Request Actions
  • Functions for Advanced Usage
    • Time-Series Matrix Transformation
      • Overview
      • Add Matrix Column
      • Change Matrix Column Setting
      • Show / Hide Column
      • Add Child Column
      • Delete Child Column
      • Format
      • Matrix Column and Formula
      • Limitations
  • Settings for Admin
    • Assign License
    • Grant Permission Set
    • Administration Console
    • Organization-Level Configuration
  • Customization
    • Access Sheet Directly with URL
    • Sheet Component
    • Embed Sheet in Layout using Visualforce
    • Using Sheet Component in Visualforce
    • JavaScript API
    • Launching Custom Apex / Visualforce
    • Launching Flow
    • Using in Experience Cloud
Powered by GitBook
On this page
  • Create Group Column
  • Add/Move Columns to/from Group Column
  • Ungroup Group Column
  • Collapse / Expand Group Column
  • Format
  1. Functions about Displaying Data

Group Column Headers

PreviousDelete ColumnNextSummary Row

Last updated 2 years ago

By grouping column headers, multiple column headers can be displayed together. Grouped columns display column headers with two rows of headers. A column that contains and displays multiple columns is called a group column.

Create Group Column

To create a group column, follow these steps:

  1. Click on the header menu at the far right of the sheet header and select "Group Column Headers".

  2. A dialog will appear, listing the columns contained in the sheet [A]

  3. Click the checkboxes to select the columns you wish to group.

  4. Enter the label of the group column header in the Header Display Label of Group Column [B].

  5. Click "Create" to create a group column with the selected column inside.

Add/Move Columns to/from Group Column

To add a column to a group column, drag the header of the column you want to add and drop it on the header of the group column or on the header of a column contained in the group column.

To move an already grouped column out of a group column, drag the header of the column you want to move and drop it on a regular column header that is not grouped.

Alternatively, you can add or move columns to or from a group column by going to the "Change Columns Display" on the header menu at the far right of the sheet header to display the Change Display Status dialog and rearrange the order of the columns.

Ungroup Group Column

To ungroup a group column, select "Ungroup" from the group column header menu.

Selecting "Delete Column" from the group column header menu will delete all columns in the group column.

Collapse / Expand Group Column

Group columns can be collapsed to show only the first column, or collapsed and expanded again to show all columns.

To collapse/expand a group column, select "Collapse" or "Expand" from the group column header menu.

Format

Group columns can be formatted. When formatting a group column, the formatting will be applied to all columns contained within the group column. If a column within the group column is formatted individually, it has precedence.

To format a group column, click "Settings" from the header menu of the group column, and set the format from the "Format" tab of the displayed settings dialog.

Conditional format is currently not available for group columns.