Hello! I have a simple problem yet I couldn't fine any if else formula that fits to solve the issue. I have two columns; [shipping_state] and [shipping_country]. I want to make it auto-fill if [shipping_state] is not blank, then [shipping_country] must automatically fill out "MYS". This is the only condition that I want to put into the formula. I tried to use IIF but I couldn't make the second column to fit into the formula.
