Field Values update

Question

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 Answer

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

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

jeetamar11 · Accepted Answer

Thank you for quick response, Alex.

It worked like wonder!😀