I have a SP2013 Server but have not been authorized to install SPD2013. I have a list [Web Team Tasker] which has a lookup column containing data from a list on a parent site as well as some subcolumns associated with the lookup column. I would like to on of the subcolumns in a calculated field. Would anyone be able to walk me through the process?


Regardless, you have SharePoint designer or not. you should be aware of the Lookup columns cannot be referenced in a calculated column formula.

Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.

Regarding the workaround:

I don't know why you don't authorize to install SharePoint designer? maybe you mean you can't install it on the server, Meanwhile, you can at least install SharePoint designer on your PC then connect to your SharePoint site.

So if you can do that the suggested workaround should be

  • Creating a simple workflow that copies the lookup column value to another column with a text data type.
  • Then use this field value in your calculated column formula.

Check the detail steps at How to use Lookup field in SharePoint Calculated Column Formula.

Note: if you have a programming knowledge, and you can't use SharePoint designer.in this case, you can create an event receiver on added and updated action to achieve the same behavior that will copy the lookup column value to another column with a text data type and in this case you can reference the text column in a calculated column formula.

  • I have SPD 2010 and the site 2013. But I will try your work around. – TroyPilewski Feb 17 '17 at 0:14
  • 1
    Are you have any issue to install SP2013 beside SP2010, also, It's preferred to install SPD2013 beside SPD 2010 if you have SP2013 meanwhile if SPD2010 not working with SP2013 take a look at blog.zubairalexander.com/… Hope it work :) Good Luck – Mohamed El-Qassas MVP Feb 17 '17 at 0:25
  • I don't administer the network I don't control what gets installed on the machines or not – TroyPilewski Feb 17 '17 at 0:26
  • Thank you. The workflow idea pointed me in the right direction. I used NinTex Workflow as the hosting facility disabled OOB workflows. – TroyPilewski Feb 17 '17 at 19:37

You can create a calculated column using your other columns in a formula, then create a new column that is a lookup to the calculated column. it works, have it in my InfoPath form.

  • This is in use with a 2010 InfoPath form hosted now in SharePoint Online, using InfoPath 2013 to slide the new lookup field into the form – Marie Apr 27 '18 at 15:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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