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.
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:
| Area | Description |
|---|
| Toolbar | Contains the save button, menu options, view selectors, and action buttons |
| Top Panel | Optional custom content area above the grid (if configured) |
| Row Headers | Display work item IDs; may be color-coded based on risk levels |
| Column Headers | Show field names, potentially organized into header groups |
| Data Cells | Contain editable (or read-only) values for each risk item field |
| Toolbar: [Save] [Menu v] [Views v] [Search] | | | | | | | |
|---|
| Top Panel (optional custom content area) | | | | | | | |
| Row | ID | Failure Mode | S | O | D | RPN | Status |
| Header | | | | | | | |
| [color] | R-01 | Brake pad wear | 8 | 4 | 6 | 192 | Open |
| [color] | R-02 | Hydraulic leak | 9 | 2 | 3 | 54 | Open |
| [color] | R-03 | ABS sensor err | 7 | 5 | 8 | 280 | Review |
Step 3: Navigate the Grid
Click any cell to select it. Use the following shortcuts to move efficiently:
| Action | Shortcut |
|---|
| Move between cells | Arrow keys |
| Jump to next column | Tab |
| Jump to row start/end | Home / End |
| Scroll by page | Page Up / Page Down |
| Enter edit mode | F2 or start typing |
| Confirm edit | Enter |
| Cancel edit | Escape |
See Keyboard Shortcuts for the complete shortcut reference.
Step 4: Edit a Cell Value
- Click a cell to select it (the cell border highlights)
- Press
F2 to enter edit mode, or simply start typing to replace the value
- For dropdown fields (severity, occurrence, detection ratings), a dropdown menu appears with available options
- Press
Enter to confirm the edit and move to the next row
- 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:
- Title / Failure Mode — Type a descriptive name (e.g., “Brake fluid contamination”)
- Severity — Select a severity rating from the dropdown
- Occurrence — Select an occurrence rating
- Detection — Select a detection rating
- 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.
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
| ID | Failure Mode | S | O | D | RPN | Status |
|---|
| R-01 | Brake pad wear | 8 | 4 | 6 | 192 | Open |
| T-01 (Mitigation Task) | Replace pad material | Planned | | | | |
| R-02 | Hydraulic line leak | 9 | 2 | 3 | 54 | Open |
| R-03 | ABS sensor failure | 7 | 5 | 8 | 280 | Review |
| T-02 (Mitigation Task) | Add redundant sensor | Open | | | | |
| R-04 | Master cylinder crack | 10 | 3 | 7 | 210 | Open |
| Color coding: Green = RPN 1-150 | Yellow = RPN 151-350 | Red = RPN > 350 | | | | |
Next Steps
Now that you can navigate, edit, and save in Risksheet, explore these topics to deepen your understanding: