For some reason my simple if statement doesn't work, but almost does. If I change the order of criteria it also functions strange.
I want the code to work as such: If code contains "SNOWBIRD" return SnowBird, if code contains "REFUSE" return Unit, otherwise return Monday.
In the picture below, if code equals "SNOWBIRD" it returns correctly, but if code equals "SNOWBIRD/RENTAL" its returning "Monday" and everything else is returned "Unit"
If I change the order of the if statements it gives just as confusing results.
