3

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?

2 Answers 2

3

First, 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.


Workarounds:

What do you mean with "you aren't authorized to install SharePoint designer?" Do you mean you can't install it on the SP server?!

Actually, you don't need to install SP Designer on the SP server, instead, install it on your PC then connect to your SharePoint site.

So if you have SharePoint designer, you can simply

  • Create a 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 piece of programming knowledge, and you can't use SharePoint designer. So, you can create an event receiver on item added and updated action to

  • Achieve the same behavior by copying the lookup column value to another column with a text data type then reference the text column in a calculated column formula.
  • Build your formula by code and save it to a field instead of using the calculated column.
4
  • I have SPD 2010 and the site 2013. But I will try your work around. Commented Feb 17, 2017 at 0:14
  • 1
    Do you have any issue to install SP2013 beside SP2010, If yes try to use JSOM to build your formula as mentioned at Auto Populate Field Values based on Lookup Selection In SharePoint. :) Good Luck Commented Feb 17, 2017 at 0:25
  • I don't administer the network I don't control what gets installed on the machines or not Commented Feb 17, 2017 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. Commented Feb 17, 2017 at 19:37
0

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.

1
  • 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
    Commented Apr 27, 2018 at 15:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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