function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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.