I am trying to get a field to auto fill based on an evaluation of a different field.
If the State field ="NY" then fill the Region field with "East"
I set the Region field type to Text, Auto-enter, Calculated field.
On the Specify screen I have the following formula: If(State="NY";"EAST";"WEST")
I do not get any results at all - am I missing something?