Ability to abbreviate long text fields in reports

What is the challenge?

There's no easy way to summarize long text fields in reports.

What is the impact?

I end up having to export reports to excel and email reports instead of use Aha.

Describe your idea

I'd like to use a formula to identify whether a text field contains more than 180 characters (length formula), and if so (if formula), return the first 180 characters (substr formula) concatenated with an ellipses "..." (+ operator) so that the report viewer knows the more information to view.

Unfortunately, I can't get Aha to produce the expected outcome. This used to work, but doesn't anymore.