Right now I have several status fields which I require users to fill in status of Green, Amber, or Red. There's a Status 1, Status 2, and Status 3 which they have to indicate the colour of. There's also an "Overall Status" which should indicate the color based on the status which is most behind (ie. if any of the 3 status is red, this will be red, or if one status is amber while others are green, this will be amber).
I'm looking for a way to automatically populate the value in "Overall Status" based on the aforementioned logic, but don't know where to start. Please would anyone have any pointers for me?