Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.