Risk Heat Map

I have developed a risk register using a rating of likelihood and severity to determine 1 of 25 possible risk profiles. I want to provide a visual presentation of the overall risk profile (summary of the whole risk register).

In the past I have developed a risk heat map in excel using a scatter diagram (with X and Y, for likelihood and severity ) and used conditional formatting to show a risk heat map.

What can I do in smartsheet to achieve something similar, or does smartsheet have other functions where I can present a summarised view of my risk register?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!