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?
First, you should be aware of the
Lookup columns cannot be referenced in a calculated column formula.
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.