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