IF Formula Tool Help

Question

Hi everyone

I have the following column and trying to transform to create the desired column:

I am in the:Seniority (desired column) Top 25% of my organisation in senioritySenior roleMiddle 50% of my organisation in seniorityNon-senior roleBottom 25% of my organisation in seniorityNon-senior roleOtherNon-senior role[Null][Null]

I've used the Formula tool with the following formula, but unfortunately it's not transforming the "Top 25% of my organisation in seniority" to "Senior role", instead it is transforming it to [Null]. This is depicted in the column below in red text:

I am in the:Seniority (desired column) Top 25% of my organisation in seniority[Null]Middle 50% of my organisation in seniorityNon-senior roleBottom 25% of my organisation in seniorityNon-senior roleOtherNon-senior role[Null][Null]

Screenshot of my formula below:

Can someone please help me troubleshoot my IF formula?

Thanks,

KA

MarqueeCrew · Answer

Did you try using the top part of my expression?

ELSEIF

Left([field],3) = "Top" THEN "Senior role"

cheers

arundaka03 · Answer

Thanks, Mark. I've just edited my post to make it clearer. Essentially my IF formula is not transforming the "Top 25% of my organisation in seniority" response to "Senior role", whilst every other value is transformed as desired.

Any ideas?

Thanks,

KA

MarqueeCrew · Answer

@arundaka03 ,

IF

IsEmpty([field]) THEN Null() ELSEIF

Left([field],3) = "Top" THEN "Senior role"

ELSE

"Non-senior role"

ENDIF

Cheers,

Mark