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 would like to create a new calculated column in Sharepoint Designer 2010. So, IN SPD 2010 / Site columns, I click New, Calculated column, fill in the details and click OK. Up comes the the Column Editor dialog box.

On the right there is a long vertical field, titled 'Insert Column' with nothing in it. Below this field there is an 'Add to formula' button. On the left there is a Formula field in which I can directly type my formula, and another field in which I can control the Data type returned.

My question is this: How do you use the field on the right to insert a column?

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

This is a bug in SharePoint Designer 2010 RTM. You can still create site level calculated columns using this dialog, but will have to reference the column names yourself. For example:

= [Principal] * [Interest Rate]

Calculated columns created in lists work as expected.

share|improve this answer
add comment

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.