Hyperlink in a table

can I make a custom formula that has a hyperlink? Ideally I'd want to link to the requestID so it open in SDP when clicked. I tried using the ConCat function and that makes the url as text, but I can't convert it to a hyperlink or a URL data type.