Field Values update

[jeetamar11]

How can i change the values in field 2 based on a specific value in field 1. All other need to remain same in field 2.

Like if 'Country' column has value Japan then Column 'Status' will have value fail otherwise whatever is in Column status remains.

Following is not working:

if [Country]= 'Japan' then [Status]= 'Fail' else [Status] endif

[alexnajm · Accepted solution]

This should work - just select the [Status] column in the Formula tool and put:

if [Country]= 'Japan' then 'Fail' else [Status] endif

[jeetamar11 · Accepted solution]

Thank you for quick response, Alex.

It worked like wonder!😀