Hello below is a table of scores and the corresponding status. I also have a risk register for each risk I want to be able to select the probability (1-5) and the Imapct (1-5) and it automatically returns the status as defined by the table below. Is it possible? Many thanks if you can help! Andrew
1 Solution
Accepted Solutions
Hi @andrewb9,
This is certainly possible with an Airtable automation. If I understand your mapping correctly, you multiply both the probability and impact scores to get a risk register number (your formula in Name) with the following criteria:
- Score of 1-5 = Low
- Score of 6-14 = Medium
- Score of 15+ = High
What you can do to automatically assign the status is to set up an automation where the trigger is "Probability" and "Impact" are both "not empty" or any other suitable trigger. From there you can set up conditional logic that follows your criteria to set the status accordingly.
Your automation would look something like this:
I hope this helps!
Chantal
Hi @andrewb9,
This is certainly possible with an Airtable automation. If I understand your mapping correctly, you multiply both the probability and impact scores to get a risk register number (your formula in Name) with the following criteria:
- Score of 1-5 = Low
- Score of 6-14 = Medium
- Score of 15+ = High
What you can do to automatically assign the status is to set up an automation where the trigger is "Probability" and "Impact" are both "not empty" or any other suitable trigger. From there you can set up conditional logic that follows your criteria to set the status accordingly.
Your automation would look something like this:
I hope this helps!
Chantal
