Hyperlink() not returning clickable text

[ellac]

Hello, 

I've created an automation rule that will send an email with  a link to the request view. The link is correct but it's returning the URL rather than hyperlinking clickable text. 

I have this written in the email body: 

<<HYPERLINK(("https://www.appsheet.com/start/c35957ac-aea4-4425-b65f-c1b8eb95843e" & LINKTOROW([REQUEST ID],"CONCIERGE_Detail")),"CONCIERGE REQUEST DETAILS")>>

Result: 

Goal: hyperlink CONCIERGE REQUEST DETAILS

---

I also have a formula that I tried to turn into a hyperlink, but again it's providing the URL but not the hyperlink clickable text. 

Formula:

HYPERLINK(
CONCATENATE(
"https://roveconcepts.freshdesk.com/a/tickets/",
ENCODEURL([TICKET NUMBER])
),
ENCODEURL([TICKET NUMBER])
)

Goal: hyperlink inputted [TICKET NUMBER]