Event Type | Risk Type | Financial Impact | Aged Days | Severity Rating | Event Type | Risk Type | Aged Days | Financial Impact | |||||
Account Issue, Payments | Financial, Reputational, Operational | $1,000,001+ | 10 | ???? | 1 | Account Issue | 1 | Financial | 1 | 0-15 | 1 | Less than $100,000 | |
1 | Payments | 1 | Reputational | 2 | 15-30 | 2 | $100,001 - $250,000 | ||||||
1 | Other | 1 | Operational | 3 | 30-60 | 3 | $250,000 - $500,000 | ||||||
1 | Corp Event | 1 | Other | 4 | 60-90 | 4 | $500,001 - $1,000,000 | ||||||
1 | Settlement | 1 | Regulatory | 5 | 90+ | 5 | $1,000,001+ | ||||||
I have a drop down list with multiple selections, is there any way to give each option a value? For instance above, in the first column, 2 things are selected, can I have that as a 2? Second column 3 things are selected so that would be a 3. | |||||||||||||
Each of the first 2 drop downs have 5 choices. | |||||||||||||
So, I would like the "severity rating" to automatically populate based on the answers in the 4 columns before it. Is the only way to do this with a macro? | |||||||||||||
The numbers to the left of the list are the values I would give for each, so your highest "severity rating" score could be 20. Based on what I have in there now, the rating would be 11. |
<tbody>
</tbody>