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?
    Zoho Marketing Automation

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now