1 Reply Latest reply on Mar 3, 2009 2:52 PM by raybaudi

    Text calculation

    soomotom

      Title

      Text calculation

      Post

      Hi,

       

      I am trying to get a field to auto fill based on an evaluation of a different field.

      Specifically:

      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?

       

      Thanks,

      Tom