Risk Heat Map

Lakmal Kamalgoda

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?

Shelby

@Lakmal Kamalgoda

Smartsheet also has conditional formatting that can be utilized to provide an easy to see presentation of risk. I've used conditional formatting to create a heat map to show risk as well.

Can you provide a screenshot of the excel sheet with the heat map you created? *hide sensitive info

Lakmal Kamalgoda

Heat Map.png

Hi,

This is what I would develop using Excel, it is a scatter diagram with gradient formatting of the colours.

Thanks

Shelby

@Lakmal Kamalgoda

Wow! Good job on the excel heat map! Not sure if something like that could be replicated in Smartsheet or not. Here's some examples of templates I found when searching for risk heat maps.

https://www.smartsheet.com/risk-register-templates