RAID Risk Matrix

WhitneyOliver ✭

11/01/24 in Formulas and Functions

Hi,

I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.

Tags:

Formulas

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Help with SUMIFS in a sheet Summary Field
Hello! I am stuck - trying to leverage a sheet summary field to sum a total, where one of the columns has two conditions that I want to exclude from the Sum. I can get one of them to work: =SUMIFS([Amount]:[Amount], [Business Unit]:[Business Unit], "Sales", [Priority]:[Priority], <>"Required") It's that last condition. I…
Returning Multiple Rows Matching the Same Value and Skipping Rows that Don't
Below is what I'm trying to do and I hope someone can help me figure out the best way to do this. Here is my source sheet, Proposals: I would like a formula to look for any "Won" values from the Status column in the source sheet and return them into the Project Name column of my destination sheet (below). I would like the…
Locking a cell after running formula or deleting a formula after it has run
Hello all. I have a bit of an issue, I wrote a formula to enter todays date after a checkbox has been checked in a cell. This works great, however if I uncheck the box the date disappears. I need the formula driven date cell to lock or hardcode the date after the formula has run once, automatically. Current formula:…

RAID Risk Matrix

Help Article Resources

Categories