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.
I’m trying to do the same based on a formula field. The output is needed to colour code a map marker in the Map app, so this calculated (Yes/No) field needs to be replicated as a Single-select field. Is this possible? I only need an automation to trigger this script twice a day.