Expression Usage

Can I use the below expression in the Formula Tool?

IF [System] = "1" or [System] = "2" THEN
[Owner] = "Brad Pitt"
ELSE [Owner] = [Primary]
ENDIF

Basically, I need to check if the field System is either 1 or 2, the field Owner must have the name "Brad Pitt" else, the field Owner must have the name in another field called Primary.

Appreciate every help that I can get

Developer Tools

Data Investigation

Accepted answers

geraldo

@Kallis

It may have spaces, you have to clean it with Trim()

All comments

geraldo

@Kallis

in the formula tool add colunn called User and use the following formula
IF [System] = "1" or [System] = "2" THEN
"Brad Pitt"
ELSE [Primary]
ENDIF

Kallis

All the fields mentioned here are Strings. The above statement returns 0 against the field Owner.

geraldo

@Kallis

your formula is wrong.
Owner must be the name of the column in the formula tool

check the formula I posted above

Kallis

Hi @geraldo

The below solution half works. I mean

IF [System] = "1" or [System] = "2" THEN ==> This is not working as expected

whereas

IF [System] = "1" THEN ==> this works

Anyway I can make the 1st statement work?

By the way, I have already created a new column called Owner

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703