Skip to main content

What You Will Achieve

By the end of this guide, you will open a Risksheet document, navigate the grid interface, create your first risk items, enter severity and occurrence ratings, see the RPN calculated automatically, and save your work back to Polarion. This guide covers the shortest path from opening Risksheet to productive use.

Prerequisites

Before starting, ensure the following:
  • Risksheet is installed on your Polarion server (see Installation)
  • You have a valid Risksheet license (production or evaluation)
  • Your user account is assigned as an active user in the Risksheet user group
  • You have access to a Polarion project with at least one Risksheet-enabled document or template
  • You are using Google Chrome or Microsoft Edge (recommended browsers)
This guide provides a general walkthrough based on a standard Risksheet deployment. Your organization’s specific configuration, column layout, and work item types may differ. The core workflow remains the same regardless of configuration. Contact your Polarion administrator if you are unsure whether Risksheet is installed or whether your account has been assigned as an active user.

Step 1: Open a Risksheet Document

Navigate to your Polarion project and open a LiveDoc document that has Risksheet configured. The Risksheet grid loads automatically within the document page, replacing the standard document view with an interactive spreadsheet-like interface. You should see a grid with column headers across the top and work item rows below. The leftmost area contains row headers showing work item identifiers. diagram
Risksheet documents are standard Polarion LiveDoc documents with a risksheet.json configuration file attached. Your project administrator can tell you which documents are Risksheet-enabled, or look for the Risksheet entry in the project navigation. The tool name may be customized (e.g., “Risk Analysis”, “FMEA Tool”) depending on your project configuration.

Step 2: Understand the Grid Layout

The Risksheet interface consists of these key areas:
AreaDescription
ToolbarContains the save button, menu options, view selectors, and action buttons
Top PanelOptional custom content area above the grid (if configured)
Row HeadersDisplay work item IDs; may be color-coded based on risk levels
Column HeadersShow field names, potentially organized into header groups
Data CellsContain editable (or read-only) values for each risk item field
Toolbar: [Save] [Menu v] [Views v] [Search]
Top Panel (optional custom content area)
RowIDFailure ModeSODRPNStatus
Header
[color]R-01Brake pad wear846192Open
[color]R-02Hydraulic leak92354Open
[color]R-03ABS sensor err758280Review

Step 3: Navigate the Grid

Click any cell to select it. Use the following shortcuts to move efficiently:
ActionShortcut
Move between cellsArrow keys
Jump to next columnTab
Jump to row start/endHome / End
Scroll by pagePage Up / Page Down
Enter edit modeF2 or start typing
Confirm editEnter
Cancel editEscape
See Keyboard Shortcuts for the complete shortcut reference.

Step 4: Edit a Cell Value

  1. Click a cell to select it (the cell border highlights)
  2. Press F2 to enter edit mode, or simply start typing to replace the value
  3. For dropdown fields (severity, occurrence, detection ratings), a dropdown menu appears with available options
  4. Press Enter to confirm the edit and move to the next row
  5. Press Escape to cancel the edit and revert to the previous value
After entering severity, occurrence, and detection ratings, the RPN column automatically calculates the Risk Priority Number using the configured formula. For a standard FMEA: Severity x Occurrence x Detection = RPN.
Some cells cannot be edited. Calculated columns (like RPN) are read-only because their values are determined by formulas. System fields (id, status, type, project) and columns marked as readOnly in the configuration also prevent editing. If a cell does not respond to editing, it is likely read-only.

Step 5: Create a New Risk Item

Right-click any cell to open the context menu. Select the option to create a new risk item (the menu label depends on your configuration — typically “New Risk” or “New Failure Mode”). A new row appears in the grid with a temporary ID (shown with an asterisk prefix, such as *NEW-1). The temporary ID is replaced with a permanent Polarion work item ID when you save. Fill in the columns:
  1. Title / Failure Mode — Type a descriptive name (e.g., “Brake fluid contamination”)
  2. Severity — Select a severity rating from the dropdown
  3. Occurrence — Select an occurrence rating
  4. Detection — Select a detection rating
  5. The RPN calculates automatically
For each risk item, you can also create downstream tasks (mitigation actions, corrective measures) by right-clicking on a risk row and selecting the task creation option from the context menu. Tasks appear as child rows beneath their parent risk item.

Step 6: Save Your Changes

Click the Save button in the toolbar. Risksheet saves all modified work items back to Polarion as a single transaction:
  • New items receive permanent Polarion work item IDs (temporary *NEW-1 becomes RISK-001)
  • Modified cells update the corresponding Polarion fields
  • Link relationships between risk items and tasks are established
  • If any part of the save fails, all changes are rolled back to prevent partial updates
Risksheet automatically maintains your Polarion session during long editing sessions via a keep-alive mechanism. You do not need to worry about session timeouts while actively working in the grid.

Step 7: Use the Context Menu

Right-click any cell to access additional actions:
  • Open Row Item — View the full work item in Polarion’s standard editor
  • Open Linked Item — Navigate to a linked work item from a link column
  • New [Type] — Create a new risk item or task at a specific level
  • Remove Row Item — Remove the selected row from the grid
  • Freeze Pane — Lock columns to the left for easier horizontal scrolling
  • Unfreeze Pane — Release locked columns

Step 8: Clear a Cell vs. Remove a Row

This is an important distinction to learn early:
  • Keyboard Delete key: Clears the content of the selected cell only. The row and work item stay intact.
  • Context menu “Remove Row Item”: Removes the entire row and deletes or unlinks the underlying work item.
Always use the keyboard Delete key when you want to erase a single value without removing the row.

Typical Grid After Data Entry

IDFailure ModeSODRPNStatus
R-01Brake pad wear846192Open
T-01 (Mitigation Task)Replace pad materialPlanned
R-02Hydraulic line leak92354Open
R-03ABS sensor failure758280Review
T-02 (Mitigation Task)Add redundant sensorOpen
R-04Master cylinder crack1037210Open
Color coding: Green = RPN 1-150Yellow = RPN 151-350Red = RPN > 350

Next Steps

Now that you can navigate, edit, and save in Risksheet, explore these topics to deepen your understanding: