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?

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.