I have two choice columns in a list :
choice column 1: values 1 posible 2 unlikely
choice column 2: values A bad B very bad
and I want to select another choice column based on the previous selected columns
choice or calculated column 3: values 1A 2A 1B 2B
What is the formula to calculate the third column? Can it be a choice column or should it be a calculated column?