Risk Assessment

Status

if(prop("Count") <= 2, "Low", if(prop("Count") <= 6, "Low-Med", if(prop("Count") <= 9, "Medium", if(prop("Count") <= 16, "Med-High", "Highest"))))

Status (One Property)

if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 2, "Low", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 6, "Low-Med", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 9, "Medium", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 16, "Med-High", "Highest"))))

Result Options

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>