=IF(Impact="H",3,IF(Impact="M",2,1)) * IF(Probability="H",3,IF(Probability="M",2,1))
| ID | Date Raised | Issue/Risk Description | Type | Impact (H/M/L) | Probability (H/M/L) | Risk Score | Owner | Mitigation Plan | Status (Open/Closed) | |----|-------------|------------------------|------|----------------|---------------------|------------|-------|----------------|---------------------| project management templates excel
Use Excel’s Slicer or AutoFilter to view by assignee or status. 5. Resource Allocation & Workload Purpose: See who is overallocated. 1)) * IF(Probability="H"