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.
Solved! Go to Solution.
We can do something as below, but I suspect your condition is " [shipping_state] is not blank"?
Yes, the condition for [shipping_state] is not blank and your solution worked out very well! Thank you!
@nasya_azureen
Glad it works. Thank you for the feedback!