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