Question regarding a matrix calculation on an input table

Good afternoon,

I am attempting to build a hazard assessment tool that would incorporate a matrix calculation on risk likelihood, severity, and risk control. I tried utilizing an input table but am having trouble configuring a calculation for the Initial Risk and End Risk Level columns.

I have assigned numeric values as follows:

Likelihood:

Certain 5

Likely 4

Possible 3

Unlikely 2

Rare 1

Severity:

Catastrophic 5

Major 4

Significant 3

Minor 2

Insignificant 1

Risk Control:

Elimination -5

Engineered -4

Substitution -3

Administrative -2

PPE -1

Please note the risk controls are negative numbers. I would like the initial risk level automatically calculated after the likelihood and severity have been input. The End Risk Level would be calculated after the risk control's have been identified.

I would also like to format the two 'risk' columns with the corresponding risk level colours as shown in the matrix that I have attached as a screen shot.

Hi there,

I hope you’re having a lovely day!

I’ll be sending your concern to our back-end support.

We’ll get back to you once I gather more information about your query.

If you have further questions don’t hesitate to reach out, we love to help!

Keep safe and may you have a lovely day!

Warmest regards,

Marlon

Hi there,

I got a word from my colleague.

You may use the Input Table field. That's close to your example and here's a guide on how to perform calculations in the input table.

How to form calculations in the input table

Don’t hesitate to contact us again if you have any questions or clarifications.

Kind regards,

Marlon