Automation to update single select field based on number

I’m working on a Risk Register. I’d like the Priority single select field to display options ranging from very low to very high, depending on the risk rating number that is returned through a formula field. For example, the formula field may determine the risk rating to be 25. I’d like the Priority single select field to display the words ‘very high’ in red. If the number value is returned as 5, I’d like the Priority field to display ‘very low’ in green.

Hi @Jan_Bryson

I think that the problem with using automations for this, is that you can’t diversify the action based on the conditional trigger. I would use a formula field with a SWITCH() function and then use a conditional color code to highlight the records depending on their risk.