Apply a Predefined Header Style
Powersheet includes 20 built-in styles you can apply directly to any column header. Add theheader property with a style reference inside your column definition:
lightpurple style.
Predefined Styles Reference
| Style Name | Text Color | Background Color | Other |
|---|---|---|---|
none | — | — | — |
boldTitle | — | — | fontWeight: 600 |
unsupported | grey800 | grey200 | textDecoration: line-through |
readOnly | — | — | Read-only visual indicator |
darkgrey | grey700 | grey200 | — |
grey | grey700 | grey100 | — |
darkred | red700 | red200 | — |
red | red700 | red100 | — |
darkorange | orange700 | orange200 | — |
orange | orange700 | orange100 | — |
darkgreen | green700 | green200 | — |
green | green700 | green100 | — |
lightgreen | green700 | primaryalt100 | — |
darkblue | blue700 | blue200 | — |
blue | blue700 | blue100 | — |
lightblue | blue700 | teal100 | — |
darkteal | teal700 | teal200 | — |
teal | teal700 | teal100 | — |
darkpurple | purple700 | purple200 | — |
purple | purple700 | purple100 | — |
lightpurple | purple700 | primary100 | — |
Define a Custom Style
To create your own style, add a definition in thestyles section and reference it by name:
Apply Styles to Column Groups
UsecolumnGroups to apply consistent styling across a set of related columns. Each group supports three style properties:
| Property | Description |
|---|---|
groupName | Display name shown in the group header row (required) |
groupStyle | Style applied to the grouped columns background (optional) |
headerStyle | Style applied to all subheader columns in the group — can be overridden per column via header.style (optional) |
collapseTo | Binding path of the column shown when the group is collapsed (optional) |
A column-level
header.style takes priority over the group-level headerStyle. Use group styles for defaults and column styles for exceptions.Color Tokens
Powersheet color tokens use a naming pattern of{color}{level} where levels range from 100 (lightest) to 700 (darkest). Available color families:
Use YAML Anchors for Reuse
Define a header style once as a YAML anchor and reuse it across columns:Header Styles
Style a Column Group Header
Column groups provide a second header row above individual columns. UsegroupStyle and headerStyle to control the appearance of the group banner and the sub-column headers within it:
| Property | Required | Description |
|---|---|---|
groupName | Yes | Display name in the group header row |
groupStyle | No | Color style for the group header band. Predefined name or custom style. Defaults to white. |
headerStyle | No | Color style applied to all sub-column headers in the group. Can be overridden per column with header.style. |
collapseTo | No | Column binding path to show when group is collapsed. Omit to disable collapse. |
columnGroup property:
Use Custom Styles in Formatters
Custom styles defined in thestyles section can also be referenced by conditional formatters for cell-level styling:
Verify
After saving the sheet configuration, reload the powersheet document. You should now see styled column headers with the colors you specified, and any column group headers displaying their configuredgroupStyle. Verify that:
- Individual column headers show the correct style
- Group headers span the correct columns with the specified
groupStyle - The
collapseTotoggle works if configured (click the collapse button in the group header)
See also
Sources
Sources
KB Articles
- Column Configuration Guide
- Column and Column Group Header Styles configuration
- Views Configuration Guide
powersheet.yaml