+ Start a Discussion

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?

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

Try this:

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