I have a formula field (text) that seems to work as expected. I say this because I pull a report, and the column with the field shows ABC123 XYZ 4567 (not exactly, but that's the gist). Anyway, I'm confident in our actual data because the report would be pulling, I'm assuming, the most direct data and it's correct.
However, a user called to my attention that for these records, when viewed in the UI (ie. going to the record view in the UI rather than just looking at the report values) the displayed value is simply, for example, ABC123 (consistently with the second portion missing). It's confusing because
- Even though it's a text field, when you create a formula, there isn't an option for a limit on characters (at least, none that I have seen) and
- The report shows the complete value!
Is this a bug, or is there something I should look into?