Cross-Site lookup and calculated list values

[TValiquette]

I would like to use the value returned from a cross-site lookup connection as part of a new value in a calculated field. When I go to set up the new list field and select "Calculated (calculation based on other columns)" then navigate to the Formula and Insert Column, the cross-site lookup field is not present as a selection.

Please advise how I can use the value from a cross-site lookup as a component in a calculated list value.

Thank you in advanced for your help.

[Dmitry Kozlov]

Hi,
SharePoint does not support all types of fields in formulas, say you cannot use User, Lookup, Taxonomy fields. I'd recommend you to move the calculation either into a workflow or JavaScript.