Formula Help

swaldon2

I am making a risk matrix and I want to be able to calculate the risk score. How can I get this formula to work? I have 5 columns, with the last column being the risk score. I cant get the formula to work and I think it is because of the other formulas in the helper column. If there is a way to achieve this please let me know!

[Helper] Likelihood formula: =IF([Likelihood (1-5)]@row = "1 - Very Low", "1", IF([Likelihood (1-5)]@row = "2 - Low", "2", IF([Likelihood (1-5)]@row = "3 - Medium", "3", IF([Likelihood (1-5)]@row = "4 - High", "4", IF([Likelihood (1-5)]@row = "5 - Very High", "5", "")))))

[Helper] Impact formula: =IF([Impact (1-5)]@row = "1 - Minor [Minimal impact on objectives]", "1", IF([Impact (1-5)]@row = "2 - Low [Slight delays or minor cost increases]", "2", IF([Impact (1-5)]@row = "3 - Moderate [Noticeable delays or moderate cost increases]", "3", IF([Impact (1-5)]@row = "4 - High [Significant impact on schedule or budget]", "4", IF([Impact (1-5)]@row = "5 - Critical [Severe impact; may jeopardize project success]", "5", "")))))

Risk Score: =[\[HELPER\] Likelihood]@row * [\[HELPER\] Impact]@row

Courtney S.

Hello! Since the numbers are always the very first character in the answers, what if you did something like this instead for your helper columns, which is much shorter and also makes sure the result is treated as a number value =VALUE(LEFT([Likelihood (1-5)]@row,1))

VALUE Function | Smartsheet Learning Center

LEFT Function | Smartsheet Learning Center

Courtney S.

Hello! Since the numbers are always the very first character in the answers, what if you did something like this instead for your helper columns, which is much shorter and also makes sure the result is treated as a number value =VALUE(LEFT([Likelihood (1-5)]@row,1))

VALUE Function | Smartsheet Learning Center

LEFT Function | Smartsheet Learning Center