SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

If you look in SharePoint Columns – Features and limitations you'll see that you can't use Hyperlink columns in a calculated field.

Your options are to use an Event Receiver or a workflow update a text column with the coumputed value.

share|improve this answer
Thanks Per, I found a third way: using a standard text field and customizing the edit form via InfoPath, so the field is readonly and has a rule that concats Title and Hyperlink. – Jan Jul 16 '12 at 14:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.