Creating a calculated field referencing a TextArea custom field

Question

Hi All, 
 
 I need to create a calculated field on an opp which is along the lines of: 
 ifelse(contains($custom_text_area_field, "This text"), "It contains this text", "It doesn't contain this text") 
 
 However, I can't find the TextArea field name in the list of available fields for the formula...! Is this not possible? I can't find any reference to it anywhere online. 
 
 Many thanks,

Nick Hocking · Accepted Answer

It seems to be a bug once we are not able to select any text area field, even a stock one. Anyway the formula works like a charm if you edit the generated extended vardefs and replace the formula accordingly, that means: 
 In Studio setup the formula: 
 ifElse(contains($name, "This text"), "It contains this text", "It doesn't contain this text") 
 Save it and then edit the file custom/Extension/modules/Opportunities/Ext/Vardefs/sugarfield_xxx.php and replace it accordingly: 
 ifElse(contains($custom_text_area_field, "This text"), "It contains this text", "It doesn't contain this text") 
 
 Finally go to Admin -> Repair and run Quick Repair and Build. 
 
 Feel free to file a Case describing this issue. 
 
 Regards