+ Start a Discussion
gilbert8109gilbert8109 

How do I Create a Checkbox Formula?

I need to create a checkbox field, but I need to be able to write a formula to populate that checkbox if certain criteria are met.

 

The checkbox should be automatically checked if a certain date has passed and the record is still in a certain opportunity stage.  I know how to write this formula, but I can't figure out how to get this formula to use a checkbox as the result type.

 

An ideas?

JakesterJakester
You'll need a regular (non-formula) checkbox field and a workflow rule to set it to true.
ShikibuShikibu

Try this:




IF(Name="foo",
IMAGE("/img/checkbox_checked.gif", "checked"),
""
)

 

and see the online help for the Image() function.
 
 
Message Edited by Shikibu on 08-23-2009 05:51 PM