I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula:
=[Title]&" ("&[Main Website]&")"
If I replace [Main Website] with a reference to a Text column, the formula works ...
Is there a way to use my URL in a calculated field?