Hi! I’m trying to create a new field on my table that is a combination of two different Single Select fields. One column is the Likelihood of an event happen (1- Rare, 2- Unlikely, 3- Possible, 4-Likely, 5- Almost certain) and the other column is the Impact of that event happening (1-Insignificant, 2-Minor, 3-Moderate, 4-Major, 5-Catastrophic). The new column that I want to create will give me a “score” from the combination of the Likelihood and the Impact (1- Low Risk, 2-Moderate Risk, 3-High Risk, 4- Critical Risk). So for example, if the event is Almost Certain (5) and but the consequences are 1- Insignificant that will mean 1-Low Risk. Could someone give me guidance on automatizing this score? Thanks!
Hi Elena. What popped into my mind quickly is this. I would make two tables, one that defines likelihood - name and “value” (probably between 0-1), and the same for impact (name and score). Then change your two columns to linked fields, the likelihood and impact tables. Then, add a lookup field using the linked column to get the numerical value associated with the primary key you selected in the linked field.
Once you have those values, you can multiply or whatever to create a combined score. There are benefits to doing it this way along with the downsides of added tables and columns (tho you can hide some of these).