Can't work out why I am getting an UNPARSEABLE error message please help


All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2

Screenshot 1

=INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row), {Risk Management Matrix Range 3},Impact@row),1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!