Forms Designer Forum

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.

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.