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
-
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
-
Hi,
This is what I would develop using Excel, it is a scatter diagram with gradient formatting of the colours.
Thanks
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!