URL data type seems to have size limit

URL data type seems to have size limit

I have created a custom formula against the Zoho Projects "Tasks" table in Zoho Reports. The custom formula concatenates the following.

 <zoho projects portal url>#taskdetail/<Project ID>/<TaskList ID>/<Task ID>

The goal of this concatenation is to create the complete URL to the specific project/tasklist/task details. I know this is proper URL because if you look at the URL in the browser when in the details of a task this is what it looks like.

After creating the formula, the value of the column shows everything correct; however, it only shows 100 characters. Therefore, some of the last part is truncated thus causing the URL to be invalid.

I know I can properly change to multi text and get more characters; however, I want the data type to be "URL" so that when I use that column in reports it will be link that can be clicked on. That works as well, but as indicated earlier, the URL is invalid due to it being truncated after 100 characters.

Is there any workaround where I can create custom column that is a URL with more than 100 characters?