+ Start a Discussion
Andrew LeesAndrew Lees 

checkbox fields in formula

I have two checkbox fields basically "#OPEN" and "#CLOSED". Bad design, I know, but not my doing! Anyway, I want to combine them into a single field with an IF statement.

Essentially, something like IF(#OPEN=TRUE, "Open", "Closed")

But I don't know how to treat the check in a checkbox. Is it "TRUE"? I keep getting a syntax error. 

Hope that's not confusing. This should be easy...
Raj VakatiRaj Vakati
Try this 
The return type of formula will be text
IF(OPEN__c=TRUE, "Open", "Closed")

 
Andrew LeesAndrew Lees
Thanks Raj. Still not working for me, but I appreciate your help.
Pawan Kumar 32Pawan Kumar 32
Andrew, Can you post the screenshot? So that we can check like which things are missing while creating the formula.