how to use if condition in script

[vanir88]

if [results] is "jan" then type "redirected to jan" in column [country]

[G3S]

are you wanting to create a new field called 'country'? or is it already an existing one?

[vanir88]

Results , country are both existing columns.

in results we have jan end , so if it is jan end then in country column "redirected to end jan" like this  value should come

[G3S]

does country column have values in it? 

if so in what scenario would you want the that value to be shown instead of 'redirected to ..'

[vanir88]

if ([Results] = "End SSD" then [Type or select country] should be "redirected to SSD")

[Results] and  [Type or select country] are existing columns

in results column we have data like ...  End SSD, End PRD, Blanks 

so if the field is End SSD  then  [Type or select country]  column data should come like "Redirected to End SSD"

[vanir88]

in country column blank will be there  wont be any data

[G3S · Accepted solution]

Try:

if ([Results] = 'End SSD', 'redirected to SSD',[Type or select country]) as [Type or select country]

[vanir88]

ok, thank you i will try this.