Change the TRUE in a column to the Column Title word

[Motivator]

High, I am trying to change the "TRUE" (Bool) return in a column to show the Column Heading/title word such as "Residential"

I am using a formula, 

But the last part says "Malformed IF statement"

Please can I have some help?

[atcodedog05]

_

[Luke_C]

Hi @Motivator 

Your statement looks to be incomplete. The syntax is IF ... Then... Else... Endif

So with your example: (using null as the else clause but you can put anything)

IF [Residential] = "TRUE"

Then "Residential"

Else null() 

Endif

[Motivator]

HI, When I use that I get "Invalid type in operator ==" for the = sign

[atcodedog05 · Accepted solution]

Hi @Motivator 

1st use select tool to convert it to v_string with length 20

2nd As @Luke_C mentioned. use above formual in a formula tool. 

Like below

Hope this helps : )

[Motivator]

Luke_C and atcodedog05,

Thanks for that, I didn't have the Select change, all Working fine now.

[atcodedog05]

Happy to help : ) @Motivator 

Cheers and have a nice day!