Step 1: Open the Sheet Configuration
- Open your powersheet document
- Go to Menu > Configuration > Edit Document Configuration
- Locate or add a
viewssection in the YAML
Step 2: Define a View
Each view is a named entry under theviews section. It specifies which columns to hide by setting their visible property to false:
Step 3: Understand View Properties
| Property | Description |
|---|---|
| View name (key) | Display name shown in the view switcher (e.g., Without V&V) |
columns | Object defining column visibility overrides for this view |
columns.<binding> | Column identified by its binding path from the columns section |
columns.<binding>.visible | Set to false to hide the column in this view |
Views control which columns are shown or hidden. They do not change column widths, formatters, or other properties. All columns not mentioned in the view remain visible at their default settings.
Step 4: Create Multiple Views
Define several views for different analysis needs:Step 5: Switch Between Views
In the sheet UI, users switch views using the view selector in the toolbar. When a view is applied:- Column visibility updates immediately based on the view definition
- The URL parameter updates to reflect the active view name
- To return to the default view, clear the view selection
Complete Example
Verify
After saving the sheet configuration, reload the powersheet document. You should now see:- The view selector appears in the toolbar with your defined view names
- Selecting a view hides the specified columns immediately
- Clearing the view selection restores all columns to their default visibility
- The URL updates to reflect the active view name
See Also
- Add a Column — define the columns that views control
- Configure a Column Group — visually organize columns
- Configure Collapsible Groups — collapse column groups as an alternative to views
- Assign Configuration to Document — link configuration to documents
Source reference
Source reference
views-configuration-guide KB article, applyView.ts, PowersheetConfig.d.ts, powersheet.yaml
Sources
Sources
KB ArticlesSupport TicketsSource Code
prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/api/document.tsprod-powersheet-src/com.nextedy.powersheet.client/src/modules/ConfigProvider/types/PowersheetConfig.d.tsprod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/index.tspowersheet.yamlprod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_composing.template.yaml