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
  • Conditional Format Setting
  • Comparison in "Equals to Values"
  • Comparison in "In Number Range"
  • Comparison in "In Date Range"
  • Comparison in "Checked / Unchecked"
  1. Functions about Displaying Data
  2. Change Column Setting

Column Setting - Format

PreviousColumn Setting - OptionsNextShow / Hide Column

Last updated 3 years ago

In the “Format” tab, you can change the appearance style settings for column data, such as colors and icons.

  • [A] Preview – Displays a preview with style settings applied

  • [B] Foregroud Color – Set the text color of the displaying data

  • [C] Background Color – Set the background color of the data cell

  • [D] Icon - Add icon when displaying data

  • [E] Icon Color - Set the color of the icon to be displayed additionally

  • [F] Icon Align - Set the alignment of the icon to be displayed additionally (left/right)

Conditional Format Setting

By adding conditions, it is also possible to change the style to be applied according to the value of data. Click on the "Add Conditional Format" link to set a condition and set the style.

Conditional formatting first determines the values to be compared and the method of comparison. By default, "This Column" is selected in Comparing to [A], and the value in the column will be the target of the conditional comparison. You can also click the "Change" link to select other columns in the sheet as comparison targets.

Condition Comparison Method [B] automatically selects the appropriate comparison method depending on the data type of the column being compared. The following types of conditional comparison methods are available:

  • Equals to Values - Enumerate candidate values and compare by exactly matching them or not.

  • In Number Range - If the value is numerical value, specify numerical ranges and compare by checking whether the value is within that ranges or not.

  • In Date Range - If the value is date or datetime value, specify date ranges and compare by checking whether the value is within that ranges or not.

  • Checked / Unchecked - Compares conditions either the comparison value has data or not (FALSE value is regarded as empty)

Comparison in "Equals to Values"

If you choose "Equals to Values" comparison, you can define multiple pairs of matching values and their corresponding formatting. When displaying the data, the first matched formatting will be applied and displayed in the order from top to bottom.

  • [A] Matching Value Input - Enter the string values (separated by commas if there are more than one) that are candidates for the matching.

  • [B] Add Conditional Format - Insert a new conditional formatting entry between the conditions.

  • [C] - Deletes the given conditional formatting and matching values pair entry.

Comparison in "In Number Range"

If you choose the "In Number Range" comparison, you can define multiple ranges separated by numbers on a number line with corresponding formatting definitions. When displaying the data, the formatting for the matching range will be applied to the data.

  • [A] Boundary Value Input - Enter number as boundary value that splits ranges

  • [B] Split Range - Splits the current number range, letting you set new boundary value and formatting.

  • [C] Include / Exclude Boundary Value - Indicates the upper/lower bounds of the range. If the boundary value is included in the range, it is filled in; if it is not included, it is highlighted in white. Click to toggle inclusion/exclusion of the boundary value in the range.

  • [D] - Deletes the given conditional formatting and the corresponding number range.

Comparison in "In Date Range"

If you choose the "In Date Range" comparison, you can define multiple ranges separated by dates on a timeline with corresponding formatting definitions. When displaying the data, the formatting for the matching range will be applied to the data.

  • [A] Boundary Date Input - Input date as boundary value that splits ranges. In addition to specific date value (e.g., "2017/4/13"), relative date value ("This Month," "Tomorrow," "Last N Months," etc.) can also be specified.

  • [B] Split Range - Splits the current date range, letting you set new boundary date and formatting.

  • [C] Include / Exclude Boundary Value - Indicates the upper/lower bounds of the range. If the boundary value is included in the range, it is filled in; if it is not included, it is highlighted in white. Click to toggle inclusion/exclusion of the boundary value in the range.

  • [D] - Deletes the given conditional formatting and the corresponding date range.

When comparing datetime values in "In Date Range" comparison, they are evaluated based on the date in the local time zone.

Comparison in "Checked / Unchecked"

If you choose to the "Checked/Unchecked" comparison, you can define two types of conditions, "Checked (With Value)" and "Unchecked (No Value)", and their corresponding formatting.

  • Checked (With Value) - Matches if the comparison value has a value other than FALSE.

  • Unchecked (No Value) - Matches if the comparison value is a FALSE value or empty.