Text Area Calculated Field Issue - Rich Text Tool Bar
We have one text area normal field and two text area calculated fields with the below formulas.
1) Text Area Field - A normal text area field
2) Text Area Calc:
IF(NOT(ISEMPTY([Test Field])),[Text Area Field])
3) Text Area Reference:
[Text Area Calc]
If "Text Area Field" contains the normal data(without using Rich Text tool bar), then the formulas are working as expected.
If "Text Area Field" contains the data which is updated using Rich Text Tool bar(Eg. Changing the font type,color etc) then the "Text Area Calc" field is not displaying the exact data present in "Text Area Field" but "Text Area Reference" calculated field is displaying the exact data.Please find the screenshot attached.
If I dont refer "Text Area Calc" field in the "Text Area Reference" calculated field then the "Text Area Calc" field is displaying data correctly.
Any pointers on this would be really helpful.
Thanks in advance.