Trim() is not trimming
I have Trim(TextFormatRemove(Self )) set as autocalculate on field with the "do not replace..." unchecked.
It is removing formatting just fine but the trim function is not working. I can go in and add spaces to end of value and they persist after I leave and come back to that field.
Any thoughts? Do I need to break up the functions?