Skip to main content

​
Prerequisites

Before setting up an Action Priority Matrix, ensure you have:

​
Step 1: Define Rating Enumerations

Add your impact and effort rating scales to the ratings section of risksheet.json: 
"ratings": {
  "impactRating": {
    "values": {
      "1": { "name": "Minimal", "id": "minimal" },
      "2": { "name": "Minor", "id": "minor" },
      "3": { "name": "Moderate", "id": "moderate" },
      "4": { "name": "Significant", "id": "significant" },
      "5": { "name": "Critical", "id": "critical" }
    }
  },
  "effortRating": {
    "values": {
      "1": { "name": "Quick Win", "id": "quick" },
      "2": { "name": "Easy", "id": "easy" },
      "3": { "name": "Medium", "id": "medium" },
      "4": { "name": "Hard", "id": "hard" },
      "5": { "name": "Major Project", "id": "major" }
    }
  }
}

​
Step 2: Create Impact and Effort Columns

Add columns to capture impact and effort ratings: 
"columns": [
  {
    "header": "Impact",
    "type": "enum:impactRating",
    "bindings": "impact",
    "id": "impact",
    "level": 2,
    "minWidth": 120
  },
  {
    "header": "Effort",
    "type": "enum:effortRating",
    "bindings": "effort",
    "id": "effort",
    "level": 2,
    "minWidth": 120
  }
]

​
Step 3: Configure Action Priority Formula

Add a formula to calculate the priority category based on impact and effort: 
"formulas": {
  "actionPriority": "function(info) { var impact = info.item['impact']; var effort = info.item['effort']; if (!impact || !effort) return null; if (impact >= 4 && effort <= 2) return 'Quick Win'; if (impact >= 4 && effort >= 3) return 'Major Project'; if (impact <= 2 && effort <= 2) return 'Fill In'; if (impact <= 2 && effort >= 3) return 'Hard Slog'; if (impact == 3 && effort <= 3) return 'Quick Win'; if (impact == 3 && effort >= 4) return 'Hard Slog'; return 'Fill In'; }"
}

​
Step 4: Add Priority Column

Create a calculated column to display the action priority: 
{
  "header": "Priority",
  "id": "priority",
  "level": 2,
  "formula": "actionPriority",
  "minWidth": 140,
  "cellDecorator": "priorityDecorator"
}

​
Step 5: Apply Conditional Formatting

Add cell decorators for visual priority indicators: 
"cellDecorators": {
  "priorityDecorator": "function(info) { var val = info.value; $(info.cell).toggleClass('priority-quick-win', val === 'Quick Win'); $(info.cell).toggleClass('priority-major', val === 'Major Project'); $(info.cell).toggleClass('priority-fill-in', val === 'Fill In'); $(info.cell).toggleClass('priority-hard-slog', val === 'Hard Slog'); }"
}

​
Step 6: Define Priority Styles

Add CSS styles to visually distinguish priorities: 
"styles": {
  ".priority-quick-win": "background-color: #d4edda !important; color: #155724 !important; font-weight: 600;",
  ".priority-major": "background-color: #fff3cd !important; color: #856404 !important; font-weight: 600;",
  ".priority-fill-in": "background-color: #e2e3e5 !important; color: #383d41 !important;",
  ".priority-hard-slog": "background-color: #f8d7da !important; color: #721c24 !important;"
}

​
Action Priority Matrix Visualization

diagram Legend:
  • Quick Win – High impact, low effort (prioritize)
  • Major Project – High impact, high effort (plan carefully)
  • ⚠️ Hard Slog – Low impact, high effort (avoid)
  • Fill In – Low impact, low effort (do if time permits)
Adjust the formula logic to match your organization’s impact/effort scales. The example uses a 5×5 matrix, but you can configure 3×3 or custom dimensions by modifying the conditional logic in the actionPriority formula.
If you’re using action priority alongside FMEA/HARA matrices on the same work item type, ensure your link roles don’t conflict. Use separate custom fields for impact/effort ratings vs. severity/occurrence/detection ratings to avoid confusion.
Enable column sorting by adding "sortable": true to the priority column definition. Users can then sort risks by Quick Win → Major Project → Fill In → Hard Slog to see the most actionable items first.

​
Verification

After applying the configuration:
  1. Open your RISKSHEET document
  2. You should see Impact and Effort columns with dropdown selectors
  3. Select values for both fields on a risk item
  4. The Priority column automatically calculates and displays the priority category with color coding
  5. Quick Win items appear in green, Major Projects in yellow, Hard Slogs in red, and Fill Ins in gray

​
See Also

KB ArticlesSupport TicketsSource Code
  • RisksheetProjectProperties.java
  • AddTaskCommand.ts
  • AppConfig.ts
  • ResultFilter.java
  • PolarionAppConfigManager.java