Print this page

Is it possible to create a formula field that has a rich text area field?

Knowledge Article Number 000113369
Description We have created a formula field that we also want to include a rich text area field.  When we go to insert the field it is not available.
Resolution Rich text area fields cannot be used in a formula.  They can be used in validation rules and workflow rules.

Certain functions cannot be used on Rich Text Area.

Example - Validation to check if Rich Text Area is empty, ISNULL cannot be used as it will not work
But instead LEN can be used. Sample formula - LEN(Rich_Text_Area_field_Name) = 0

But if Picture is inserted in the Rich Text Area LEN will also not work unless a space is added after the picture

promote demote