> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nextedy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure Column Visibility

> Control which columns are displayed in the Nextedy RISKSHEET grid through the sheet configuration, saved views, personal preferences, and runtime toggling.

export const LastReviewed = ({date}) => {
  if (!date) return null;
  const formatted = new Date(`${date}T00:00:00Z`).toLocaleDateString("en-US", {
    year: "numeric",
    month: "long",
    day: "numeric",
    timeZone: "UTC"
  });
  return <p className="mt-10 text-sm text-gray-400 dark:text-zinc-500 not-prose">
      Last reviewed on {formatted}
    </p>;
};

## Set Default Visibility in Column Configuration

Each column definition in the sheet configuration supports a `visible` property that controls its default display state. Set `visible` to `false` to hide a column by default:

```yaml theme={null}
columns:
  - bindings: title
    header: Title
    visible: true
  - bindings: description
    header: Description
    visible: false
  - bindings: severity
    header: S
    type: enum:severity
  - bindings: helperCalc
    header: Calc
    formula: calcHelper
    visible: false
```

When `visible` is not specified, it defaults to `true`. Hidden columns remain part of the sheet configuration and can be made visible through saved views or the column visibility selector.

Note that `bindings` is the property that maps a column to a Polarion work item field. The sheet configuration file (`risksheet.json`) is editable through a YAML editor with syntax highlighting and validation in v25.5.0 and later.

## Use Saved Views for Predefined Layouts

Define multiple column visibility presets in the `views` array. Each view lists the column IDs to display using the `columnIds` property:

```yaml theme={null}
views:
  - name: Full Analysis
    defaultView: true
    columnIds:
      - "@all"
  - name: Review View
    columnIds:
      - systemItemId
      - title
      - sev
      - occ
      - det
      - rpn
  - name: Export View
    columnIds:
      - "@all"
      - "-helperCalc"
      - "-internalNotes"
```

Views support several powerful mechanisms for selecting which columns appear:

* **`columnIds`** -- the array of column IDs to display in this view. This is the correct property name; the legacy form `columns` is not recognized by the engine.
* **`defaultView: true`** -- marks which view loads automatically when the sheet opens (v24.1.0+). At most one view should set this. If no view is marked, the first view in the array becomes the initial selection.
* **`"@all"`** -- a special shorthand that includes every column defined in the sheet configuration, in declaration order.
* **`"-columnId"`** -- a hyphen prefix excludes a specific column from the selection. This is most useful combined with `"@all"`: start from every column, then remove a few.

Users switch between views using the view selector in the toolbar. The grid immediately updates to show only the columns listed in the selected view.

<Frame>
  <img src="https://mintcdn.com/none-17b4493f/yWl5nA2D0IzEnZC1/risksheet/diagrams/guides/customization/column-visibility/diagram-1.svg?fit=max&auto=format&n=yWl5nA2D0IzEnZC1&q=85&s=5f6efdde51dc9a3a47298f736baaf6f7" alt="diagram" style={{ maxWidth: "500px", width: "100%" }} width="500" height="380" data-path="risksheet/diagrams/guides/customization/column-visibility/diagram-1.svg" />
</Frame>

<Warning title="Formulas depend on column visibility">
  If a formula column is hidden, its formula does not execute on sheet load. Do not rely on hidden formula columns for calculations that other visible columns depend on. Use saved views to control export layouts rather than permanently hiding formula columns.
</Warning>

## Enable Personal Column Selection

Users can further customize their view using **Select visible columns** in the toolbar. This setting persists on the user's local computer across sessions.

<Tip title="Personal visibility resets when switching views">
  The **Select visible columns** selection is saved to the user's browser storage. However, switching to a different saved view resets any personal column visibility changes. After switching views, users need to re-apply their personal column preferences.
</Tip>

## Save and Reset Column Settings

Users can persist or restore their column width and visibility customizations:

* **Save columns** -- saves the current column width and visibility as personal settings. A confirmation prompt prevents accidental saves.
* **Reset columns** -- restores column width and visibility to the default sheet configuration, removing all personal customizations. The sheet refreshes automatically after reset.

| Action                      | Scope     | Persistence                     | Notes                                   |
| --------------------------- | --------- | ------------------------------- | --------------------------------------- |
| Column `visible` property   | All users | Permanent (sheet configuration) | Set in the sheet configuration          |
| Saved views (`views`)       | All users | Permanent (sheet configuration) | Admin-defined presets using `columnIds` |
| `defaultView` view property | All users | Permanent (sheet configuration) | Marks which view loads first (v24.1.0+) |
| Select visible columns      | Per user  | Browser storage                 | Resets on view switch                   |
| Save columns                | Per user  | Server-side                     | Survives browser changes                |
| Reset columns               | Per user  | Removes personal settings       | Confirmation required                   |

## Toggle Review Columns

Review columns can be toggled independently using the review toggle command. This shows or hides the review and add-review system columns (`SYSTEM_COL_REVIEWS` and `SYSTEM_COL_REVIEWSADD`), and automatically adjusts row heights to accommodate the changed layout.

<Note title="Column group collapse is not persistent">
  The `collapseTo` column group collapse state resets on every page reload. For persistent column hiding, use saved views or the **Select visible columns** feature instead of relying on column group collapsing.
</Note>

## Control Visibility in Exports

For PDF exports, use the `hideColumns` parameter to temporarily hide columns during the export process. Columns are hidden during export and automatically restored afterward:

```javascript theme={null}
// In pdfscript.js — hide helper columns during export
exporter.exportMainSheet("helperCalc,internalNotes");
```

A cleaner alternative is to define an export-specific saved view that uses `"@all"` with `-columnId` exclusions to omit helper columns, then switch to it before exporting.

<Warning title="Do not set an export view as the default">
  If the export view is marked with `defaultView: true`, formulas in hidden columns will not execute on sheet load. This may cause incorrect calculated values. Always keep the full analysis view as the default and switch to the export view only immediately before exporting.
</Warning>

## Verify Your Changes

You should now see the view selector dropdown in the toolbar with your defined views. The view marked `defaultView: true` should be selected on initial load. Switching views should toggle column visibility immediately, including correct handling of `"@all"` and `-columnId` exclusions. The **Select visible columns** option should persist your choices until you switch views. The **Reset columns** command should restore the original sheet configuration.

## See Also

* [Create Saved Views](/risksheet/guides/customization/saved-views) -- define saved view presets in detail
* [Control Column Visibility in Exports](/risksheet/guides/export/column-visibility-export) -- export-specific visibility
* [Work with Formulas and Hidden Columns](/risksheet/guides/advanced/formulas-hidden-columns) -- formula interaction with visibility
* [Control Column Visibility](/risksheet/guides/columns/column-visibility) -- column-level visibility settings

<LastReviewed date="2026-06-09" />