How to create field based on other field

[Naps_230]

Hi All,

I have some data. I need to create field 'Home Away' based on 'Ground' Field .

if Ground out of India it will be Away otherwise Home in script.

Ground	Home Away
Melbourne	Away
Manchester	Away
Lord's	Away
Bengaluru	Home
Delhi	Home

Please any one help me.

[YoussefBelloum]

Hi,

it is better to have/create a field "country" where you can found the Country related to each Ground, like this

Ground               |     Country

Melbourne          |     Australia

Manchester        |     England

Bengaluru          I     India

Delhi                  I     India

then you can do this: If(Country<>'India','Away','Home')

otherwise if you don't have such column, you should hardcod it on the script..